First column is the total count, 2nd is the type of the object (could be the activity), third is the month is was created (or month of the activity).

Please run this in query analyser to see the resultset it presents :

Declare @StartD as datetime

declare @EndD as datetime

declare @Year as int

set @Year = 2004

set @StartD = dateadd(YYYY, @Year...

Yes ron k and again this will scan only 1 month at the time. Unless this is exactly what you (kristin) want it to do then I would urge you...

Let's just hope for the best untill then...

That's what I was about to finish typing .

I guessed that he would consider doing this himself. Cause if he didn't I wouldn't want be working with him anyways . (not...

Hey ron... I guess it's starting to sink in now

"where reportsentdate >= @StartD and reportsentdate < @EndD"

Even with a static number, that number can always be changed later on in the lifetime of the application. That's why I preffer doing this work with 2 simple loops...

It's simple really, but the fact is that it's much simpler to run a single query than to run 12. My 2 count() were mere exemple for the aggregates that...

Maybe someone has a better solution... but providing that this is for administrative work :

EXEC master..xp_cmdshell 'dos command to move file here', no_output

R u talking about an actual file or a text column?

I think this will do all you want in a single query :

Declare @StartD as datetime

declare @EndD as datetime

declare @Year as int

set @Year = 2004

set @StartD = dateadd(YYYY, @Year...

can't you concatenate then split in excel?

Or actually why don't you just join the tables then using 2 while loops, you could generate the results on the client, which would...

Please refer to this demo.

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

I see Frank... Looks like I'm gonna get to 10k posts before you do at your current pace.