Your table DDL doesn't match your query unless I missed something in all the code.

😎

Also, what's wrong with just doing this:

SELECT

count(*)

FROM

[MAGICSSHD].[Incident] WITH (NOLOCK)

WHERE

[State:] = N'C'

AND ([InActive:] = 0)

...

Besides formating your code, we could also use the DDL of the base table, including any and all indexes you have defined.

😎

Everyone has their own way of laying out code. This is how I like to do it using the example several have used in this thread:

SELECT

...

Guess I'll have to check this out from home. Can't view the site here at work.

😎

Time to ask a question, why the sub-total every 5 records? Seems to me this should probably be done on the application side, not the database side of things...

The only gotcha I would warn about is regarding SSIS packages. When you create an SSIS package with a script task, be sure to select the option to precompile...

There is another way to do this, without using convert. The second select statement is equivalent to the first:

select datediff(week, convert(varchar(6), getdate(), 112) + '01', getdate()) + 1

select datediff(week,...

Not that I am aware of, sorry. You can setup a DDL trigger to capture that event at a server level, or setup a trace to capture that as...

I think the difference between a 5 of 10 and a 9 of 10 (to use a scale) isn't so much the amount of knowledge but more the intuitive thought...

It isn't that we are trying to down play our knowledge, it just the more we learn, we learn that there is more we don't know.

Maybe I am better than...

Life lesson -- There is always something new to learn, even when you think you know it all!

You can bury me when I stop learning.

Actually, I haven't even thrown in SSIS, SSRS, or SSAS. If I added those in, my score would drop. On SSIS (2 or 3 of 10), SSRS (1...

GSquared (3/3/2008)

Lynn Pettis (3/2/2008)

....

I appreciate the compliment. Now you've set the bar for me even higher. I would be lucky to put myself at 5 out 10...

You are even more limited if you are using the embedded version of SQL Server that is loaded in a single server install. We have two installations of Windows...