Having AS as optional seems a little loose to me.

The outer join will ensure that all records from fSystemCalendarRollups are grouped and returned in the result set.

Where the outer join was unsuccessful the values in the fLabourRedDayParts will be...

Is there a case for not using a temp table or table variable at all? If you wrap your temp table select statement in the from clause of your insert...

Is there changes to the INSERT statement in SS2K8? I would like to be able to specify the value to be inserted into a column next to its definition in...

Can't argue with the facts

How are the chances of using indexes diminished? I ran this script to see how conversions deal with clustered indexes. For this test it still used the clustered indexes in...

I found in a situation where you want to join by date only, convert your two date columns to its integer representation in the JOIN or WHERE clause when comparing...

Another thing that helped the performance of this table is having the id column as the integer representation of that particular day.

Eg. With today being 11/04/2007 (dd/mm/yyyy)

SELECT 'TodayAsInt' =...

Yeah I can see the simplicity of that.

Another thought to bring into the equation is the benefits of having a single row for each day of the year within the...

I guess its a case of multiple dates with one region or one date with multiple regions.

What if your country has different public holidays within each individual state or you need to have public holidays for many countries within the same table?

A simple way to...