SQL Row to Column

Purpose: To merge multi-line values of the same condition into the same column.

1. Create a Test table:

CREATE TABLE [dbo].[tb_01](    [SN] [nvarchar]( -)NULL,    [Step_name] [nvarchar]( -)NULL,    [sdate] [datetime] NULL)  on [PRIMARY]

2. Insert the test data:

INSERT  intoTb_01VALUES('V000001','FQC','2015-01-01 10:20')INSERT  intoTb_01VALUES('V000001','OQC','2015-01-02 07:35')INSERT  intoTb_01VALUES('V000002','FQC','2015-05-23 15:26')

3. Raw Data results:

Expected data format:

V000001 FQC (2015-01-01 10:20:00), OQC (2015-01-02-07:35:00)
V000002 FQC (2015-05-23-15:26:00)

4. Using the For XML path implementation:

SELECTSN, Left(Steps,LEN(Steps)-1) asAAAAA from (        SELECTSN, (SELECTStep_name+'('+CONVERT(VARCHAR( -), Sdate, -)+')'+','   fromtb_01WHERESN=a.sn forXML PATH ("')) asSteps fromtb_01 AGROUP  bySN) B

Final Result:

SQL Row to Column