Display row value as a TABLE column using SQL select statement

Question

Display row value as a TABLE column using SQL select statement

Vijaya Kumar Gulappa

SSChasing Mays

Points: 633
More actions
October 29, 2007 at 9:50 pm

#199517

Comments posted to this topic are about the item Display row value as a TABLE column using SQL select statement
Blog: Gulappa

Viewing 4 posts - 1 through 3 (of 3 total)

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

Ulysses_Infinity SSCrazy Points: 2588 More actions · Answer 1

This is a fairly poor Featured Script. Isn't the point to shed some light on the methodology rather than simply posting script and result. And where's the DDL code?

Cadavre SSC-Forever Points: 41690 More actions · Answer 2

Ulysses_Infinity (1/13/2012)
This is a fairly poor Featured Script. Isn't the point to shed some light on the methodology rather than simply posting script and result. And where's the DDL code?

Try these articles by Jeff Moden which talk about the same technique in much more detail -> Part 1[/url] and Part 2[/url]

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

May 11, 2016 at 7:17 am

#1878209

Thanks for the script.