Unfortunately you cannot do this directly in TSQL. However as was discussed in another thread you can create a job or executable to make a connection to the server and...

Have you considered maybe a zero reply option similar in function to active threads. And also may want to note last poster name is Site Owners somewhere so new folks...

This should do it, alos changed to use INNER JOIN SQL standard.

Update mwebWorkCalcs

set mwebWorkCalcs.WorkCalcs_Actual_Hrs=(select isnull(sum(TASK.WorkCalcs_Actual_Hrs),0.0)

from

MWEBWOR

INNER JOIN

MWEBWORKCALCS TASK

ON

TASK.WORKCALCS_WORK_ID = WORK_ID AND TASK.WORKCALCS_WORK_ENTITY_TYPE=4

WHERE

(case mwebWorkCalcs.workCalcs_Work_Level

when 3 then...

It doesn't hurt to make a backup copy of either that you can restore to any server for testing and troubleshooting issues that seem to only occurr on one server...

Sorry, just want to cover the why. Technically, however, I never hit enter so the paragraph is actually 1 line long.

"Don't roll your eyes at me. I...

Ok, just to clear things up. Looping thru and not changing the string will work that way. However once the execution of the loop or process is over and the...

simonsabin,

quote:

---

this will allow the use of compile queries.

---

I am confused by this and some other...

Consider what happens if no record meets the some_condition. In that case there are no rows returned which in turn means there isn't even a NULL value to work with....

Instead of using sysporcesses, setup an on DELETE trigger that runs

select system_user, host_name(), app_name()

which will give you the actual login name of the user that fired delete, the machine they...

What version of SQL Server are you running?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

From what you state it is best performed at the UPDATE itself in an SP or UPDATE statement. The only CON with a TRIGGER to do this is that it...

Something like this

SELECT COUNT(DISTINCT SSN) FROM myTbl WHERE Status_ID = 60

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Two things.

First take out the ON ERROR RESUME NEXT or at least only use it when you want to trap a specific error and immediately do ON ERROR GOTO 0...

Check your registration of the server and if using an alias defined in Client Network utility, verify it is correct.

"Don't roll your eyes at me. I will tape them in...

Sorry you can only do that with dynamic SQL as the string will be passed as '<> B' and not <> 'B'

You could however create several procedures with each having...