Hi,

Based on Jessie's good work, try the following SQL.

Put it before

drop #m

drop #d

Select T.oid, T.cid, T.odt, Max(T.step1) AS TStep1, Max(T.Step2) AS TStep2, Max(T.Step3) AS TStep3

FROM (

Select M.*

, CASE...

Hi,

Try the following script to load csv file into SQL server.

Create table with the the fields to match up with the CSV file.

Update rowterminator or fieldterminator accordingly based on...