This is a very good article. To be complete it only needs to explain semi-joins, anti-semi-joins and cross apply.

If someone could explain how cross apply works, I'd be a...

One more question:

What happens if you run:

select (100000000000000000000000000000000 * convert(numeric(6),(convert(int,((convert(numeric(7,2),[ObservanceTime],126) - 35000.00) * 100.0)) % 1000000)) + 1000000000000000000000000.0 * ([SourceID] % 100000000) + 10000000000000000.0 * ([TargetID] % 100000000) + 1000000000.0...

Might be worthwhile logging a call to the company... how they managed to get an index on that column is a bit beyond me 🙂

I've tested it and it works on 2005, however the function ::fn_get_sql is going to be deprecated by Microsoft.

I believe that another way is to do the following:

/* code to...