Excellent article. I have a real-life example of the need for a Cross Join in production. Inside my stored procedure, it is necessary that I check conditions against each company/state/county...

Brilliant Gila! 😎

I thought perhaps the where clause may have been messing me up, but I was too close to the problem to see the solution.

Thanks for the insight.

In order to simplify the process, you may just want to have two fields instead of one TimeSpan field.

You could create the table with StartTime and EndTime fields. You could...

It is important to discover the reason why all these financial institutions got into trouble at the same time. Certainly, one company's portfolio could affect another's, but why did so...

Great comments everyone.

This code introduced me to the WITH statement. perhaps I had seen it before, but I apparently put it out of my mind.

From what I've read, this...