NHS Baz (6/29/2016)
Thanks for the input folks but does anyone have an answer to the question that was actaully posed in the original post?
It would be nice to have some sample data and expected output so we can test possible solutions.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service