Transpose Query Output

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sunny.mohan SSC Veteran Points: 269 More actions · Answer 1

What is the real benefit of this query when we have the pivot in sql server?

Florian Cechi SSC Veteran Points: 267 More actions · Answer 2

SSC Veteran

Points: 267

February 22, 2013 at 7:47 am

Pivot? On Sql 2000? 🙂

sunny.mohan SSC Veteran Points: 269 More actions · Answer 3

SSC Veteran

Points: 269

February 22, 2013 at 10:27 am

Yes, it may not be available on SQL 2000.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

May 2, 2016 at 4:10 pm

Thanks for the script.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

sunny.mohan (2/22/2013)
What is the real benefit of this query when we have the pivot in sql server?

I guess I need to learn to use Pivot.