I have a CSV file that I bulk loaded into a single column staging table.

I need a way to parse proper csv files that are comma delimited with optional...

Thanks for the great info.

I was previously using a modified version of

Jeff Moden's Tally OH! An Improved SQL 8K “CSV Splitter” Function

to parse text files that where pipe...

Thank you Wayne

This was exactly what I needed to solve an issue I had with an SSIS package that had dynamic columns in a csv file.

I needed to check for...

Thank you!!

This process worked great except my master database collation was different from my new re-created database so I had to modify the script.

I was getting error

"Cannot resolve the...