Final Edit,

Dwain, I figured out why yours didnt work you're addind on the Julian day which is 1-365/366

I think you need to add the Week day number ...

Id love to see the GenerateCalendar function.

Coming from a DW background the persisted calendar table is second nature, and I'm surprised more traditional OLTP systems dont implement one...

Nice Alternative dwain, love the use of cross applys with the tally and inline month generator, as well as the normalisation of the month to always be the first.

That makes sense, and I can see why you're having problems.

Is it possible to get the Columns renamed in the XML source or is this a fixed definition?

One thing...

Why cant you just name the columns differently? Especially if its a temporary thing like a table variable.

Sorry to say It Depends, usually the data volumes, budget etc will dictate these things.

We tend to split everything out, even down to having seperate Servers for SSAS, SSRS and...

I tend to have a generic calendar table build of which this is a cut down version.

This is the one I tend to use as a prepopulation staging table...

Thanks anthony, I'm sure there will be one I'll do some digging.

Thanks Anthony, I was curious as I've been thinking of using the Google API to get Geo-spatial data for locations, as well as using the google data with a 2012...

The Codeplex solution Looks very nice.

Out of curiosity what are you using google analytics for, is it a matter of data enrichment (Geo codes etc) or is there some other...

Welcome to SSC, DDL would be nice but this is not really a difficult problem so I've mocked up the data to suit, but for future refrence the DDL (table...

Personally I would run the overnight loads independantly on each environment with Prod being the priority environment.

this way your data is then pretty much in sync, with the exception of...

I already provided that solution but the poster needs to add more logic so I've provided the additional solutions, which should...

Ok, I didnt realise there was any other logic.

This is a way to do it with a Left Join

Select t2.*

from #temp2 t2

Left Join #temp1 t1 on t2.StudentLocalID=t1.StudentLocalID and...

this should work

Select * from #temp2

EXCEPT

Select * from #temp1