(Urgent !!!) Row to column [message #35845] |
Fri, 19 October 2001 01:46 |
yopy
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
Hi guys,
i am need a help to change row data to column data
using SQL
for example i have query table like this :
date_stamp start_time tag_name tag_value
---------- ---------- -------- ---------
07-sep-01 20:00:00 A 1
07-sep-01 20:00:00 B 2
07-sep-01 20:00:00 C 3
07-sep-01 21:00:00 A 4
07-sep-01 21:00:00 B 5
07-sep-01 21:00:00 C 6
and i want to be like this
date_stamp tag_name 20:00:00 21:00:00
---------- -------- -------- --------
07-sep-01 A 1 4
07-sep-01 B 2 5
07-sep-01 C 3 6
so, what do i have suppose to do ?
regards
yopy
----------------------------------------------------------------------
|
|
|