jamie 82947 (8/11/2013)
Ok so I can get the 'CSV Splitter' working but that only does a string. I need to read the data in from a table which could have any number of rows. I used a cursor in mine to read in each row in the table and only used a loop for the actual splitter.I also need this to be in a View as it could be updated by any number of people at any time.
Is there any other help out there as to how I can do this in a View please?
Not an expert in this syntax, but I believe you can call CROSS APPLY on the split function for every row of your table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP