Nice script, I look forward to trying it myself!

You could use a cursor that steps through each unique SeqNo and dynamically generate your pivot statement, which you would fire with an EXECUTE statement. There are plenty of...

Kishore.P said:

try like this:

select ID, isnull (firstname, '') + ' ' + isnull (middlename, '') + ' ' + isnull (lastname, ''), isnull (address, ''), isnull (phoneno, '') from contact...