jfogel (6/13/2014)
Lynn Pettis (6/13/2014)
jfogel (6/13/2014)
Ah, I see. Once I remarked out two of the select statements in Lynn's query before the cross apply I see just the desired result. Much more graceful method than mine.The first two selects were to display the initial data after the inserts. I used that to do a visual verification of my results.
I got that. I'm just not even sure what I was thinking. The whole question was how to do it without dynamic SQL and I turn around and propose something based on just that. I'm going to try and avoid touching anything important today!
I know how you feel.