No, unfortunately order is not guaranteed when assigning to variables.

I couldn't believe it when I first heard of it, but I can confirm it is so.

Your technique for retrieving the first non-zero value in variables is quite smart, but please be advised that the order is NOT guaranteed. It may work today, could go totally...

Congrats, Roy!

Today I ran across the strangest threads I've ever seen here on SSC:

Want to buy a Ford car?

A sad story from Colorado

They don't seem to be automatic spam, but, evidently,...

I would be glad to help, but I need some more information.

Take a look at the article linked in my signature, you'll find out how to ask for help...

Basically, you just have to move the indexes.

Take a look at this article by Martin Bell, I think you will find enlightening.

Hope this helps

Gianluca

Nice code, Mr. Coffee!

Looks like you specialized in pivot/unpivot lately...

That's ok, I think I got it:

UPDATE @test-2

SET Field1 = (SELECT TOP 1 Field1 FROM @Test2 WHERE T1Id = T1.Id AND Field1 != 0 ORDER BY Id),

Field2 = (SELECT...

It doesn't look this code does what the OP wants.

Are you...

This should do the trick for you:

UPDATE @test-2

SET t1.Field1 = (CASE WHEN t1.Field1 = 0 THEN t2.Field1 ELSE t1.Field1 END),

t1.Field2 = (CASE...

I think I almost understood what you mean, but it would be clearer with some more information:

1) Table scripts

2) Sample data

3) Expected output

4) What you tried so far

See the article...

Do database and schema name match?

Try selecting the procedure from object explorer and from context menu choose "Script procedure as" --> "Execute to" -->"New Query editor window"

Dave put a neat example in his post, last query.

Some links for you:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99653

http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspx

Doesn't KeePass[/url] fit your needs?