Yeah well I guess that is more a function of it using views on top of a COTS application database based on two primary tables Component and Relationship. The system...

This is great! I have been using the Coalesce function in a udf for this purpose, but this method is faster. I didn't use it as a correlated subquery, but...

I have had a situation with a stored procedure with a lot of search parameters with many table joins and min/max date ranges for date fields that got to be...