Yeah... that's the bugger about it... @variable=column=formula ONLY works for Update and only with certain other "hooks" present....

See "expanding hierarchies" in books online.  There's lot's of other methods but that one is pretty easy.

For wicked speed, try the following URL with the understanding that it takes a...

That and a strong, respectful salute to the folks in the armed services who made it possible and continue to make it possible to enjoy such freedoms!  Thank you all.

Never mind about the @WhereClause... was going to try to make it so you didn't need the dynamic SQL, but I can't wait for it...

One of the common methods for...

Working on this but need some info... what column names will you use in the @WhereClause variable for this proc only?  Please give an example of what you will pass...

Shrinking the log file causes fragmentation.

Very hard to say... people normally use cursors when they think there is no set-based option... normally they are wrong.  Replacements will many times consist of the ill-conceived notion that...

Like a couple of folks have asked already... post the rest of the code that uses the cursor and describe what the code is supposed to do.  We're pretty good...

Bill,

If YOU didn't know about the backups being taken, who does?  Who's changing the tapes?

Must be an echo, eh?

Understood.  Me?  I export the data to a file and zip it so it won't be a duplication of data in the database.

Works kinda the same way with images... if a...

There may be some normal "healthy" blocking going on... you sure these are "deadlocks" (found in the SQL Server log) and not just blocking?

Not in SQL Server 2000, you can't... this IS an SQL Server 2000 forum, ya know?

Sorry, Chris... lost track of this thread...

Specifically, what statement gave you that error?