I completely agree with automating everything and have been doing that since day one. I automate everything from data loading processes, I probably have about 200 daily and monthly,...

Looks like the same query but good call on the isnull protecting against if there are no answers for a particular question.

I might be off base here but this is what it looks like to me; however, this will give you multiple QuestionTreeUID's and Question counts that are the same but will...

That's interesting... I did not know that could be done either.  Any chance you could provide an example?  I use cursors all the time and would love to loop through tables...

Why did you say to disregard?  Did you figure out how to do this?

The way I prefer to do this is to add a sql task with the following query:

declare @day varchar(2), @month varchar(2), @year char(4), @filedate char(8), @cmd sysname

set @day = datepart(dd,...