Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anandbohra
Starting Member
4 Posts |
 Posted - 2007-06-09 : 03:43:50
|
| Dear alli am newbie to this forum as well as learning SQL so don't have much knowledge.i want one query which will transpose data in columni have 3 filedsScrip--COC--DAteA--25--01/06/07B--34--01/06/07C--65--01/06/07A--65--02/06/07B--98--02/06/07C--37--02/06/07now i want a query which shows data in this waySCRIP--01/06/07--02/06/07--03/06/07A--25--65--....B--34--98--....C--65--37--....now this date column will be only 5 i.e. 1 which user puts + 4 preceding dates from user date (ignoring sequence means if user put 10/06/07 then next will be 09/06/07 but if this wont exists then take 08/06/07 & so on till 4 dates)the data will be unique means no scrip repeats more than once in a daypl reply soon |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Data required in Column