show column data into rows

Hello everybody,

i want to show the column data into row wised how it can be done pleas guide .

am trying to write a query that can show column data row wise. For example :

if I have a table called MyTbl which contains ID, DATE and Value fields and the data in the table is

ID DATE VALUE
1 2000-10-30 00:00:00.000 68
2 2000-10-30 00:00:00.000 68
3 2000-10-30 00:00:00.000 69
1 2001-03-23 00:00:00.000 66
2 2001-03-23 00:00:00.000 67
3 2001-03-23 00:00:00.000 66
1 2001-03-24 00:00:00.000 66
2 2001-03-25 00:00:00.000 67
3 2001-03-26 00:00:00.000 66

I want to get the following result from SQL query

1 2 3 Date

68 68 69 2000-10-30 00:00:00.000
66 67 66 2001-03-23 00:00:00.000
66 67 66 2001-03-24 00:00:00.000

Can anybody help me to find the appropriate query.