Stored Procedure Question

[Ann]

I need to write a stored procedure that takes the following data:

ID Sequence ColumnName
71 1 CustomerAccountName
71 2 RevenueClass

And loops through the record set to concatenate Column Name into a string.

The result should look like this:

ID ColumnName
71 CustomerAccountNameRevenueClass

Can you tell me how to do this?

[David Portas]

SELECT id,
MAX(CASE sequence WHEN 1 THEN columnname ELSE '' END)+
MAX(CASE sequence WHEN 2 THEN columnname ELSE '' END)+
MAX(CASE sequence WHEN 3 THEN columnname ELSE '' END)+
MAX(CASE sequence WHEN 4 THEN columnname ELSE '' END)+
...
FROM SomeTable
GROUP BY id

--
David Portas
SQL Server MVP
--

[Hirantha]

try
http://groups.google.com/groups?q=sq...+rows&hl=en&lr
=&ie=UTF-8&oe=UTF-8&safe=off&selm=%23u19EkNHEHA.700%40TK2MSFTNGP09.p hx.g
bl&rnum=10

--
hth
Hirantha
Please reply only to the newsgroups.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Hirantha]

try
http://groups.google.com/groups?q=sq...+rows&hl=en&lr
=&ie=UTF-8&oe=UTF-8&safe=off&selm=%23u19EkNHEHA.700%40TK2MSFTNGP09.p hx.g
bl&rnum=10

--
hth
Hirantha
Please reply only to the newsgroups.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!