Eliza (10/7/2012)
1. bcp the table to a file.
2. BULK INSERT from the file to a new table using comma as a delimiter.
3. Report success. 🙂
This wouldn't work as its a view for a report so I cannot constantly put the data into a file. The view needs to do the chopping for the data but thank you.
Report to be generated as what?
File, I guess?
Then ditch the step 2:
1. bcp the table to a file.
2. Report success. 🙂
Whoever reads the report can never tell a column-separating comma from a comma in a list of values.
Its' gonna be the same ASCII character.
_____________
Code for TallyGenerator