March 23rd, 2004, 02:35 PM
|
|
Registered User
|
|
Join Date: Feb 2004
Location: Victoria, BC, Canada
Posts: 8
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Moving column data into other columns
Hi,
I have a table with a column that lists 3 things, 'added', 'changed' and 'deleted'. I would like to set up the table so that each of the 3 things is in its own column based on a date range (I can do the date range part). What I cannot do is get the 3 items into their own columns. Any suggestions? Using SQL server 2000.
Thanks,
Cam
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
