hello everybody,
I'am new to SQLServer.I have records from table as follows.
column1 column2 column3 column4 column5
-------- ------------------- ------- ------ ---------
Y 2004-02-17 00:00:00.000 0.00 152.70 0.00 0.00
WSC 2004-02-17 00:00:00.000 1.34 285.00 0.34 0.00
WPO 2004-02-17 00:00:00.000 7.00 650.03 0.77 0.00
SSEZY 2004-02-17 00:00:00.000 5.89 94.31 4.64 0.00
SEB 2004-02-17 00:00:00.000 3.00 195.00 0.88 0.00
NVR 2004-02-17 00:00:00.000 0.00 297.01 0.00 0.00
MKL 2004-02-17 00:00:00.000 0.00 205.75 0.00 0.00
GREY 2004-02-17 00:00:00.000 4.00 594.60 0.58 0.00
FARM 2004-02-17 00:00:00.000 3.80 301.00 1.23 0.00
BRK.A 2004-02-17 00:00:00.000 0.00 61500.00 0.00
Y 2004-01-30 00:00:00.000 0.00 152.70 0.00 0.00
WSC 2004-01-30 00:00:00.000 1.34 285.00 0.37
WPO 2004-01-30 00:00:00.000 5.80 650.03 0.69
SSEZY 2004-01-30 00:00:00.000 5.89 94.31 5.05
SEB 2004-01-30 00:00:00.000 3.00 195.00 0.98
NVR 2004-01-30 00:00:00.000 0.00 297.01 0.00
MKL 2004-01-30 00:00:00.000 0.00 202.00 0.00
GREY 2004-01-30 00:00:00.000 4.00 594.60 0.59
FARM 2004-01-30 00:00:00.000 3.80 301.00 1.21
BRK.A 2004-01-30 00:00:00.000 0.00 60600.00 0.00
Y 2003-12-31 00:00:00.000 0.00 152.70 0.00
WSC 2003-12-31 00:00:00.000 1.34 285.00 0.38
WPO 2003-12-31 00:00:00.000 5.80 650.03 0.73
SSEZY 2003-12-31 00:00:00.000 5.89 94.31 4.89
SEB 2003-12-31 00:00:00.000 3.00 195.00 1.06
NVR 2003-12-31 00:00:00.000 0.00 297.01 0.00
MKL 2003-12-31 00:00:00.000 0.00 201.50 0.00
GREY 2003-12-31 00:00:00.000 4.00 594.60 0.59
FARM 2003-12-31 00:00:00.000 3.80 303.24 1.21
BRK.A 2003-12-31 00:00:00.000 0.00 60600.00 0.00
Y 2003-11-28 00:00:00.000 0.00 152.70 0.00
WSC 2003-11-28 00:00:00.000 1.34 285.00 0.38
WPO 2003-11-28 00:00:00.000 5.80 650.03 0.72
SSEZY 2003-11-28 00:00:00.000 5.89 94.31 5.25
SEB 2003-11-28 00:00:00.000 3.00 195.00 1.30
NVR 2003-11-28 00:00:00.000 0.00 297.01 0.00
MKL 2003-11-28 00:00:00.000 0.00 197.00 0.00
GREY 2003-11-28 00:00:00.000 4.00 573.10 0.58
FARM 2003-11-28 00:00:00.000 3.80 302.12 1.19
Y 2003-10-31 00:00:00.000 0.00 152.70 0.00
WSC 2003-10-31 00:00:00.000 1.34 285.00 0.41
WPO 2003-10-31 00:00:00.000 5.80 650.03 0.79
SEB 2003-10-31 00:00:00.000 3.00 195.00 1.17
NVR 2003-10-31 00:00:00.000 0.00 297.01 0.00
MKL 2003-10-31 00:00:00.000 0.00 189.50 0.00
GREY 2003-10-31 00:00:00.000 4.00 565.10 0.60
FARM 2003-10-31 00:00:00.000 3.60 302.01 1.12
BRK.A 2003-10-31 00:00:00.000 0.00 60600.00 0.00
Y 2003-09-30 00:00:00.000 0.00 152.70 0.00
WSC 2003-09-30 00:00:00.000 1.34 285.00 0.39
WPO 2003-09-30 00:00:00.000 5.80 645.79 0.87
SEB 2003-09-30 00:00:00.000 3.00 195.00 1.39
NVR 2003-09-30 00:00:00.000 0.00 270.50 0.00
MKL 2003-09-30 00:00:00.000 0.00 187.50 0.00
GREY 2003-09-30 00:00:00.000 4.00 540.00 0.53
FARM 2003-09-30 00:00:00.000 3.60 301.01 1.12
BRK.A 2003-09-30 00:00:00.000 0.00 60600.00 0.00
Y 2003-08-29 00:00:00.000 0.00 152.70 0.00
WSC 2003-08-29 00:00:00.000 1.34 285.00 0.42
WPO 2003-08-29 00:00:00.000 5.80 620.00 0.83
SEB 2003-08-29 00:00:00.000 3.00 195.00 1.30
NVR 2003-08-29 00:00:00.000 0.00 270.50 0.00
MKL 2003-08-29 00:00:00.000 0.00 187.50 0.00
GREY 2003-08-29 00:00:00.000 4.00 508.00 0.52
FARM 2003-08-29 00:00:00.000 3.60 301.01 1.03
BRK.A 2003-08-29 00:00:00.000 0.00 60600.00 0.00
Y 2003-07-31 00:00:00.000 0.00 152.70 0.00
WSC 2003-07-31 00:00:00.000 1.34 285.00 0.42
WPO 2003-07-31 00:00:00.000 5.80 603.00 0.86
SEB 2003-07-31 00:00:00.000 3.00 195.00 1.13
NVR 2003-07-31 00:00:00.000 0.00 264.00 0.00
MKL 2003-07-31 00:00:00.000 0.00 187.50 0.00
GREY 2003-07-31 00:00:00.000 4.00 508.00 0.51
FARM 2003-07-31 00:00:00.000 3.60 301.01 1.07
BRK.A 2003-07-31 00:00:00.000 0.00 60600.00 0.00
Y 2003-06-30 00:00:00.000 0.00 152.70 0.00
WSC 2003-06-30 00:00:00.000 1.34 285.00 0.43
WPO 2003-06-30 00:00:00.000 5.80 516.00 0.79
SEB 2003-06-30 00:00:00.000 3.00 195.00 1.45
NVR 2003-06-30 00:00:00.000 0.00 242.00 0.00
MKL 2003-06-30 00:00:00.000 0.00 175.00 0.00
GREY 2003-06-30 00:00:00.000 4.00 508.00 0.52
FARM 2003-06-30 00:00:00.000 3.60 301.01 1.06
BRK.A 2003-06-30 00:00:00.000 0.00 59600.00 0.00
Y 2003-05-30 00:00:00.000 0.00 152.70 0.00
WSC 2003-05-30 00:00:00.000 1.34 285.00 0.44
WPO 2003-05-30 00:00:00.000 5.80 516.00 0.80
SEB 2003-05-30 00:00:00.000 3.00 195.00 1.36
NVR 2003-05-30 00:00:00.000 0.00 242.00 0.00
MKL 2003-05-30 00:00:00.000 0.00 175.00 0.00
GREY 2003-05-30 00:00:00.000 4.00 508.00 0.61
FARM 2003-05-30 00:00:00.000 3.60 301.01 1.12
BRK.A 2003-05-30 00:00:00.000 0.00 59600.00 0.00
but from the above my dispaly must be as follows
************************************************** **********************
Ticker Item 2/17/2004 1/30/2004 12/31/2003 11/28/2003 10/31/2003
9/30/2003 8/29/2003 7/31/2003 6/30/2003
Y Dividend 0.00 0.00 0.00 0.00 1.34 5.80 3.00 0.00 0.00 4.00
52 week Low 152.70 152.70 152.70 152.70 285.00 645.79 195.00
264.00 175.00 508.00
Yield 0.00 0.00 0.00 0.00 0.41 0.87 1.30 0.00 0.00 0.61
WSC Dividend 1.34 1.34 1.34 1.34 5.80 3.00 0.00 0.00 4.00 3.60
52 week Low 285.00 285.00 285.00 285.00 650.03 195.00 270.50
187.50 508.00 301.01
Yield 0.34 0.37 0.38 0.38 0.79 1.39 0.00 0.00 0.52 1.12
WPO Dividend 7.00 5.80 5.80 5.80 3.00 0.00 0.00 4.00 3.60 0.00
52 week Low 650.03 650.03 650.03 650.03 195.00 270.50 187.50
508.00 301.01 59600.00
Yield 0.77 0.69 0.73 0.72 1.17 0.00 0.00 0.51 1.06 0.00
SSEZY Dividend 5.89 5.89 5.89 5.89 0.00 0.00 4.00 3.60 0.00
52 week Low 94.31 94.31 94.31 94.31 297.01 187.50 508.00
301.01 59600.00
Yield 4.64 5.05 4.89 5.25 0.00 0.00 0.52 1.07 0.00
SEB Dividend 3.00 3.00 3.00 3.00 0.00 4.00 3.60 0.00 0.00
52 week Low 195.00 195.00 195.00 195.00 189.50 540.00 301.01
60600.00 152.70
Yield 0.88 0.98 1.06 1.30 0.00 0.53 1.03 0.00 0.00
NVR Dividend 0.00 0.00 0.00 0.00 4.00 3.60 0.00 0.00 1.34
52 week Low 297.01 297.01 297.01 297.01 565.10 301.01
60600.00 152.70 285.00
Yield 0.00 0.00 0.00 0.00 0.60 1.12 0.00 0.00 0.44
MKL Dividend 0.00 0.00 0.00 0.00 3.60 0.00 0.00 1.34 5.80
52 week Low 205.75 202.00 201.50 197.00 302.01 60600.00
152.70 285.00 516.00
Yield 0.00 0.00 0.00 0.00 1.12 0.00 0.00 0.43 0.80
GREY Dividend 4.00 4.00 4.00 4.00 0.00 0.00 1.34 5.80 3.00
52 week Low 594.60 594.60 594.60 573.10 60600.00 152.70
285.00 516.00 195.00
Yield 0.58 0.59 0.59 0.58 0.00 0.00 0.42 0.79 1.36
FARM Dividend 3.80 3.80 3.80 3.80 0.00 1.34 5.80 3.00 0.00
52 week Low 301.00 301.00 303.24 302.12 152.70 285.00 603.00
195.00 242.00
Yield 1.23 1.21 1.21 1.19 0.00 0.42 0.86 1.45 0.00
BRK.A Dividend 0.00 0.00 0.00 0.00 1.34 5.80 3.00 0.00 0.00
52 week Low 61500.00 60600.00 60600.00 152.70 285.00 620.00
195.00 242.00 175.00
Yield 0.00 0.00 0.00 0.00 0.39 0.83 1.13 0.00 0.00
************************************************** ***************************
can anyboby help??please..