PIVOT Table in .NET

IF NOT OBJECT_ID(N'#tmp') IS NULL DROP TABLE #tmp


CREATE TABLE #tmp(Doc_Id INT, CL_Id INT, CL_Desc NVARCHAR(30), Rev_No INT, dwg_status_code NVARCHAR(30), EMP_Name NVARCHAR(30))

INSERT INTO #tmp (Doc_Id, CL_Id, CL_Desc, Rev_No, dwg_status_code, EMP_Name)
VALUES(146508, 15, 'C-BF-FT-02 R2',	0,	'DWS000002', NULL)
INSERT INTO #tmp (Doc_Id, CL_Id, CL_Desc, Rev_No, dwg_status_code, EMP_Name)
VALUES(146508, 15, 'C-BF-FT-02 R2',	0,	'DWS000003', NULL)
INSERT INTO #tmp (Doc_Id, CL_Id, CL_Desc, Rev_No, dwg_status_code, EMP_Name)
VALUES(146508, 15, 'C-BF-FT-02 R2',	0,	'DWS000025', NULL)
INSERT INTO #tmp (Doc_Id, CL_Id, CL_Desc, Rev_No, dwg_status_code, EMP_Name)
VALUES(146508, 16, 'C-BF-FT-03 R2',	0,	'DWS000002', 'KARTHIKEYAN K')
INSERT INTO #tmp (Doc_Id, CL_Id, CL_Desc, Rev_No, dwg_status_code, EMP_Name)
VALUES(146508, 16, 'C-BF-FT-03 R2',	0,	'DWS000003', 'KARTHIKEYAN K')
INSERT INTO #tmp (Doc_Id, CL_Id, CL_Desc, Rev_No, dwg_status_code, EMP_Name)
VALUES(146508, 16, 'C-BF-FT-03 R2',	0,	'DWS000025', 'KARTHIKEYAN K')

--SELECT *
--FROM #tmp

DECLARE @cols NVARCHAR(300)
DECLARE @dt NVARCHAR(2000)
DECLARE @pt NVARCHAR(MAX)

SET @cols = STUFF((SELECT DISTINCT '],[' + dwg_status_code
					FROM #tmp
					ORDER BY '],[' + dwg_status_code
			FOR XML PATH('')),1,2,'') + ']'

SET @dt = N'SELECT * FROM #tmp'

SET @pt = N'SELECT Doc_Id, CL_Id, CL_Desc, Rev_No, ' + @cols + ' ' +
		'FROM ( ' + @dt + ') AS DT ' + 
		'PIVOT(MIN([EMP_Name]) FOR [dwg_status_code] IN(' + @cols + ')) AS PT'

EXEC(@pt)

DROP TABLE #tmp