The only area of improvement that I can...

Check the registry. On my system, it's located at:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ClientSetup, and the key is SQLToolsPath.

Does this get you what you're looking for?

SELECT dti.Dat_Date, i.In_ID

FROM (

SELECT *

...

To see the value of any variable, just select @variable.

To see the contents of temp tables, just select * from #temptable.

Of course, this will need to be done within the...

I would suggest adding a "select @ExistingID" to the end of your code, and see what you get.

Bezan,

David's solution rocks. Just use that.

Click here for the latest Delimited Split Function.

Then, it's just:

SELECT ITEM

FROM dbo.DelimitedSplit8k(@val, ',')

Whoa... VERY NICE!

Edit: I really like using the dates in the case statements... kinda obvious when you see it.

Bezan,

I've really enjoyed this exercise. It's nice to see someone that isn't posting "do it all for me" - you are working the problem, reading what is being suggested, implementing...

I just modified it to combine all the sql generation that runs against the tally table to run in just one select statement - reducing the # of reads against...

Bezan (9/2/2010)

---

There is no WayneS improvement: "One thing that can be done to improve on my solution, it to take the first 2 CTEs and pump that data into a...

Yes - you're calling CTE2 5...

LightVader (9/2/2010)

---

Derrick Smith (9/1/2010)

---

After I verify everything is working as it should (Backups being taken regularly, replication/log shipping/mirroring working OK, no outstanding issues/problems), I set up a centralized reporting database...

Check your dmv's for missing indexes.

What I generally do is to add a parameter to the procedure:

@debug tinyint = 0

Then, within the code, do things like:

if @debug > 0 select ....

if @debug > 1 select...