HTH.

Another neat trick that you might like :

select id, txtData From Yourtable order by case txtDate when 'html' then 0 else 1 end

If you, as I hope, pursue this solution, make sure that the date column is indexed in the activity table. The best case would be to have it be...

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...