• 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!

    Cheers