|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
Wow!
I figured it out on my own.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Moving column data into other columns |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|