I attended the Seattle event earlier this week. I was concerned that it would be a day-long commercial for Red Gate, and due to pressures at work, I almost blew...

Oops... that delete query should have been this:

DELETE #tblName

WHERE UniqueID IN (

 SELECT TOP 10

 UniqueID

 FROM #tblName

 ORDER BY UniqueID

)

Maybe something like this -- Create a tmp table with a unique identifier, populate the table, then loop through the tmp table based on the unique ID:

CREATE TABLE #tblName (

 UniqueID...

You could also try using the task scheduler. It should give you the option of ending the task after a specified amount of time.

Maybe something like this:

select *

from tblname

where

floor =

 case

  when region='east' then ('floor'+'suite'+'room')

  when region = 'west' then 'floor'

 end

and suite =

 case when region = 'west' then 'suite'

  when region = 'east' then ''...

You may be running into a problem with Parameter Sniffing. Good details in this article:

http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/a61d6b3fd1a32b08?output=gplain

As a workaround, you could try assigning some local variables with the values passed from the...

Do you think it would help if you changed this line:

when @status = 'Stagnant' then 9

to:

Else 9

You may be running into a problem with Parameter Sniffing. Good details in this article:

http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/a61d6b3fd1a32b08?output=gplain

As a workaround, you could try assigning some local variables with the values passed from the variables...