--create table for importing data create table DataImpTest ( Title1 varchar(100), Title2 varchar(1000) ) --do the bulk insert BULK INSERT DataImpTest FROM '<File Path>\DataImp.csv' WITH ( FIELDTERMINATOR =' ', ROWTERMINATOR = '\n', FIRSTROW=2 ); --check the imported data SELECT * FROM DataImpTest -- fix the unequal spacing in Title2 column UPDATE DataImpTest SET Title2 = LTRIM(RTRIM(Title2)) --check the trimmed data SELECT * FROM DataImpTest --pivoting the data to columns SELECT * FROM DataImpTest AS t PIVOT(MAX(Title2) FOR Title1 IN ([Name],[State],[PSComputerName],[RunspaceId]))p /* Output --------------------------------------- Name State PSComputerName RunspaceId ----------------------------------------------------------------------------- Default Web Site Stopped s07 c62cf173-af1f-46bd-a57f-3b29e74998ed
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)