R Brush and Chris M, thank you so very much for taking the time for this contribution. This is helpful. I mulled over much of the query yesterday to "see" it myself. Also introduces new clauses to me such as CROSS APPLY. So in ChrisM’s query, post 558, the CROSS APPLY part, is this equivalent to that calculated column concept? Could I also achieve this in a sub query? Purposely asking this for understanding. I sense a limitation - that I would not be able to “refer”, “point” or use the result the sub query calculates, CROSS APPLY will allow this. Ill also reference BOL, although at times the explanations are abstract for me.
Thank you again.
As soon as you see something, you already start to intellectualize it. As soon as you intellectualize something, it is no longer what you saw. Suzuki-roshi