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 |
|
vijays3
Constraint Violating Yak Guru
354 Posts |
 Posted - 2012-09-13 : 11:00:51
|
| [code]Hi All,I have following table.In Which for each status there is daily count ctr is to determine first day ,second day and so on .Currently I found only two status It might be more like failed to mapped,Reissued. But right now I am not bother about them.ctr Status StatusID dailyCount1 Item ready 10 851 Cancelled 550 122 Item ready 10 832 Cancelled 550 83 Item ready 10 793 Cancelled 550 64 Item ready 10 764 Cancelled 550 4I am expecting result in below format I tried to implement using dynamic Pivot but result was not expected .Could someone guild me on this .. Ctr Item ready Cancelled1 85 122 83 83 79 64 76 4[/code]Vijay is here to learn something from you guys. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Pivoting data