Barsuk (heck of a handle there),

First, I hope your times look like 12:30 and not 12.30 or we'll have to do a bit more wittling...

The key to the problem is...

I dunno... call me "old school"... This will always round up to the base as well. 

SELECT ROUND(@Value/@Base+.499999,0)*@Base

Also, just curious... why would you need to round up to...

Sukio,

Like I said in one of your previous posts, lookup "expanding hierarchies" in "Books on Line".  With a minor amount of tweeking, it will do exactly what you want.

Rohit,

The setbased logic you used in your example will almost always beat Cursors and WHILE loops.  Do you need any reason other than speed?  Ok, how about resource intensity, duration...

Sukio,

There is an example query in "Books on Line".  To find it, lookup "expanding hierarchies" in the BOL index.  Be advised that it is not "bug free" and will require...

1)  Is the default on 'SELECT * FROM x' to lock each row?

I don't believe so but could be wrong.

2)  Should all SELECTS have WITH (NOLOCK)?

Only if it's OK to...

This should do it with some assumptions... the assumptions are that you will have no title (Mr., Mrs., etc) and no suffic (Jr. Sr. II, III, IV, etc).

/******...

David,

If Edward is correct and all you really want is to split the last name from the rest and we assume that the last name will appear after the last...

You have to convert @Count to VARCHAR or CHAR

Hi Midan,

Guess there might be a little problem with the language barrier thing... let me see if I can clear it up...

I believe your problem is that you want to...

Sukhoi,

I don't know if the little bit of "language barrier" between us is a problem or if I'm just misreading this... just want to make sure you aren't stepping onto...

Sukhoi,

Again, as in the post I answered for you previously, you need to do some conversions in the concatenization.  You have to CONVERT the date to VARCHAR or CHAR.  See...

Sukhoi,

It's funny how the error message is sometimes the opposite of what it should be...

Your problem is that the contents of one or more of your variables are numeric and...

You never mentioned how long it was taking for the update...

My experience for these two table type of single column update joins says you'll get about 4 million rows...

paolice,

Understood... I use "trial and error" a lot.  But you still haven't given me a clue as to how to use DataLength to determine the defined length of a column. ...