This UDF parses a comma delimited string and returns a table with the parse strings as rows.
Usage: select * from fn+PareseString('12,13,14,67')
Will return a table with the following rows
12
13
14
67
Can be modified to have an additional parameter for the type of delimiter.
Write Reports from SQL to Disk (Even HTML!)
Ever need to write reports out to a folder? I have found that creating output files are SA-WEET! (and easy too) The sample script uses BCP to create an HTML file.This process works well for reports that need to be generated nightly and take too long to run in real time. Use an SMTP mail […]
2002-04-18
4,307 reads