INSERT INTO ITDataAll ( FileName, [1099 Y/N], SetId, VendorId, Location, Name1, Name2, Address1, Address2, Address3, Address4, City, State, Zip, TIN_Type, TIN, Withhold_Name1, Withhold_Name2, WH_Address1, WH_Address2, WH_Address3, WH_Address4, WH_City, WH_State, WH_Zip, WH_Code, Paid_Amt, Pay_Date, [Check] )
SELECT IT_Orig_Data.FileName, GetValueFromDelimString([AllFields],0) AS 1099YN,
GetValueFromDelimString([AllFields],1) AS SetId,
GetValueFromDelimString([AllFields],2) AS VendorID,
GetValueFromDelimString([AllFields],3) AS Location,
GetValueFromDelimString([AllFields],4) AS Name1,
GetValueFromDelimString([AllFields],5) AS Name2,
GetValueFromDelimString([AllFields],6) AS Address1,
GetValueFromDelimString([AllFields],7) AS Address2,
GetValueFromDelimString([AllFields],8) AS Address3,
GetValueFromDelimString([AllFields],9) AS Address4,
GetValueFromDelimString([AllFields],10) AS City,
GetValueFromDelimString([AllFields],11) AS State,
GetValueFromDelimString([AllFields],12) AS Zip,
GetValueFromDelimString([AllFields],13) AS TIN_Type,
GetValueFromDelimString([AllFields],14) AS TIN,
GetValueFromDelimString([AllFields],15) AS Withhold_Name1,
GetValueFromDelimString([AllFields],16) AS Withhold_Name2,
GetValueFromDelimString([AllFields],17) AS WH_Address1,
GetValueFromDelimString([AllFields],18) AS WH_Address2,
GetValueFromDelimString([AllFields],19) AS WH_Address3,
GetValueFromDelimString([AllFields],20) AS WH_Address4,
GetValueFromDelimString([AllFields],21) AS WH_City,
GetValueFromDelimString([AllFields],22) AS WH_State,
GetValueFromDelimString([AllFields],23) AS WH_Zip,
GetValueFromDelimString([AllFields],24) AS WH_Code,
GetValueFromDelimString([AllFields],25) AS Paid_Amt,
GetValueFromDelimString([AllFields],26) AS [Date],
GetValueFromDelimString([AllFields],27) AS [Check]
FROM IT_Orig_Data;