What do you mean by "robs me"?

It should be as simple as this:

declare @sqlstring varchar(500)

set @sqlstring = 'update sql code where '+@wherevar+'rest of sql code'

exec (@sqlstring)

For dynamic SQL you'll need to use the exec command and treat the whole statement as a concatenanted string.

See:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ea-ez_05ro.asp

You need a "where" clause on that update to only update the row in question.

If all you want is to have them in the same physical file, do this:

Create Proc spB (

                                  )

As

  Begin

....

end

GO

Create Proc spA (

                                  )

As

  Begin

....

end

GO

That way you won't get sysdepends errors.

This isn't really good...

What information are you trying to get from the DATETIME column?

Try select into a temp table then run your cursor / update off of that.

Try this:

SELECT userid, name, email

FROM users usr

LEFT OUTER JOIN usersubscriptions usub ON usr.userid = usub.userid

and

usub.subscriptionid IN (1254, 1167)

where usub.subscriptionid is null

I stumbled upon Phil's method by happenstance late Friday.  Will look at the other method.

Thanks.

Starting up traces does indeed affect performance but whether or not it is enough to impact other jobs is uncertain.  If you were running a trace, what did the trace...

Diagnostic Manager is an excellent SQL Server monitoring tool that will capture this and much more for you.

(Not involved, just a satisfied user.)

Steve, I hadn't heard that before.  We actually do have another solution that will get rid of that problem as well as the deadlocking on tblStatus, we just need to...

Basic setup:  2 applications that take XML files and load them into a working table.

                  4 applications that each take "ownership" of a specified number of data objects (bills) and process...

Yanno, i tried this once before and query analyzer yelled at me.  Just tried it again and it appears to work fine.

As far as the other response, we've tried using...