Converting Multiple Rows into Single Column

This is one example for coverting Multiple Rows into Single Column.

DECLARE @TABLE TABLE
(SNO INT)
DECLARE @STRING CHAR(10)
INSERT @TABLE
SELECT 1
UNION
SELECT 2
UNION
SELECT 3
UNION
SELECT 4
UNION
SELECT 5
SELECT * FROM @TABLE
SET @STRING=''
SELECT @STRING=CONVERT(VARCHAR(50),SNO)+';'+@STRING
FROM @TABLE
SELECT LEFT(@STRING,LEN(@STRING)-1)

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server