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 |
|
shaik.zakeer
Posting Yak Master
117 Posts |
 Posted - 2009-11-06 : 09:21:12
|
| i have a result set likeitem scr date1 date2 rating 100 2 3comments 100 abc defaa 7 null nullbb 6 null nullcc 5 null nulldd 4 null null ee 3 null nullff 2 null nulli want to convert this resultset into like the below item scr date1 date2 rating 100 2 3aa 7 null nullbb 6 null nullcc 5 null nulldd 4 null null ee 3 null defff 2 abc null note: i am getting the actual resultset thru dynamic queries and the date columns are getting generated based on the period selected.can i able to do this.Thanks Jack |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-06 : 09:32:46
|
I cannot see a logic to decide when 'def' or 'abc' is to put into a column.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
shaik.zakeer
Posting Yak Master
117 Posts |
Posted - 2009-11-06 : 09:55:34
|
| if date1 = 7 then we need to place the comments at score = 7 place.Here date1 is 2 that's why i placed 'abc' in score = 2 position.same thing date2 is 3 that's why i placed 'def' in score = 3 position.hope this is what you are expecting......Thanks Jack |
|
|
|
|
|
|
need help on dynamic query