If the VARCHAR(MAX) column is intended to store large values (and I suppose the chances of that are quite good), a temporary table has one other advantage: you can use...

Thanks John - I should have acknowledged Wesley's contribution in my previous post.

I apologise in advance if I am missing the obvious, but doesn't the definition of ##keys in the first code sample include a column called 'key_owner', whereas the second version...

Oh dear, I posted a reply to that identity-order thread before checking here :ermm:

I got the checksum question wrong by the way - fell into the 'single bit error' bear...

Gabriel P (2/18/2010)

---

Hey does anyone know if it's possible to do this solution but insure that the fields/variables are updated in a specific order for each row?

Like say I...

Thanks. I have updated my...

I hope not - but even if that is the case, I would hope that...

Dave Ballantyne (2/18/2010)

---

If I...

A gate bangs open and shut in the wind...

A tumble-weed rolls by...

It is dark.

There might be grues.

Depending how your mind works, you might find this solution more intuitive:

-- Test table

CREATE TABLE #ReconRecord

(

serial ...

Tara-1044200 (2/17/2010)

---

I want to update memkey,state and empno in table Emp_CA where memekey is found with null value. these 3 columns should be updated from the table OBBEAVER.dbo.memberlist whic also...

Alif,

I've read your question several times now, and given it some thought...but I'm afraid I can't understand what you are asking for here.

Please take another shot at explaining what you...

Tom.Thomson (2/16/2010)

---

This is some confusion as to the range in which parameter 13 is usable. In general it can be used for intercontintal transfers in ranges up to roughly 1178.39...

You're my favourite SSC Editor, Steve. Thanks. 😀

I...