Posted by Plamen Ratchev on 05/29/07 12:37

Using UNPIVOT in SQL Server 2005:

SELECT ID, Name, Device
FROM Foobar
UNPIVOT
(Device FOR DeviceType IN
(HomePhone, WorkPhone, Email)) AS U;

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: What do you think about the checksum function ?
• Prev in forum: Re: needed: 1 + null = 1
• Thread view: Re: Transpose column into rows

[Reply to this message]