Remi is spot on both in statement and method suggested... you still don't need a cursor to do that.  Do like remi recommended...

First, you have a major bug in the code you posted... you don't create a value for @GenInfo_ID variable which means that you are populating the GenInfo_ID column of the...

Serqiy is correct... is the stuff you putting into @List available in a table anywhere?  If so, we can resolve the whole table instead of using RBAR methods...

If you're talking about the method in the URL I provided and not the BOL solution, some indexes will certainly help once the tree for the whole DB is constructed. ...

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?