Just to clarify what we all want...

Page navigation at the top AND bottom pls.

TIA .

That's why it's called a Gotcha .

Is it essential to run that after updating the stats or even reindexing the DB?

... was at lunnh break.  Also we are not your servants.  So if you need something of that order I suggest you hire yourself a programmer, or better, a DBA.

Does...

Don't have to but I would strongly suggest using where condition that can use an index!!

Make it as narrow as possible... since you seem to be short on space ATM!

I would miss the code for sp_Demo

Also I totally agree with vasc on this one.  You are heading straight for problems with this solution (unless we misunderstand the requirements)!

Can you post the version of the porcs you are utilizing pls?

Are you telling me that this works

SELECT CalcAction FROM ClaimCounts_Test

WHERE CalcAction='Total Record Count'OR CalcAction='Record Count of Unique Claims '

ORDER BY CASE

WHEN CalcAction='Total Record Count' THEN 2

WHEN  CalcAction='Record...

CREATE PROCEDURE dbo.SpDemo

AS

SELECT CalcAction FROM ClaimCounts_Test

WHERE CalcAction='Total Record Count'OR CalcAction='Record Count of Unique Claims '

ORDER BY CASE

WHEN CalcAction='Total Record Count' THEN 2

WHEN  CalcAction='Record Count of...

I feel you pain... However I don't see any way of speeding up this thing.

Maybe a concatenation funcion could do it by I don't know your schema enough to create...

"Don't take this personnally" means I don't want to offend but I must know...

Anyhow vasc showed you another way (better) of doing this.  Let us know how it works for...

Stupid question alert : Why not use varchar(4000) instead of 40????

But I think the guy is wel aware of it and the error he mentioned showing that the problem is...

Wow, great catch... I wouldn't have caught that one soon (sorry barely never use Dynamic sql &nbsp...

1 - What is your training in programmation and in SQL server 2000?

2 - Why are you creating a permanent table in the proc (recompilations are not performance's best friend)?

3...

Check out books online (BOL). The section CREATE TRIGGER will surely help you a lot!

You'll also find plenty of information on this site alone!