The Detailed Data column needs to be separated into separate COLUMNS of data based on the TAB spacing.
Each Full Record contains Rows that start with "1,2,5 and 7". I believe there can be 1 or many rows for each "1,2,5,7" but it appears that most multiple rows show up in the "5" type.
I need help in creating a sql script that will step through this table and separate the DetailedData field into separate fields.
Thanks
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft SQL Server 2005
I can't provide exact code for that since I don't have ready-to-use data. But I think a combination of ROW_NUMBER() and the split could be made to work.
I don't have time to convert that splat of data into create table and insert statements. that takes more time -- and is far more boring -- than writing the final query.
Can this be used with a "tab delimited" source field?
The documentation states that it is specifically coded for a "Single Character Delimiter", change at your own risk...