DennisPost (11/24/2014)
Thanks for the tip Sean. No .sql available, had to make a choice.Here it is again as .doc and .zip.
Can also do .txt or post all 1130 lines of code if anyone prefers.
Replacing on potentially dangerous file type with another is not going to do much for you. What do you mean by no .sql available? Don't you have the content for a file as that? Wouldn't be too hard to change the extension of a text file to sql.
Why do you need 1130 lines to demonstrate the issue here? Or are you saying your function is 1130 lines?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/