KGJ-Dev (7/28/2015)
Hi mister,nope, the data is not consistent.
Hi WayneS,
thank you so much for working query. I am curious to learn about cross apply used here. I will play with that. Appreciated your time on this post.
For learning about CROSS APPLY, see the "Using APPLY Part 1" and "Part 2" links in my signature below.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes