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
Can be modified to have an additional parameter for the type of delimiter.
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 […]