Thank you. Will give it a try.

Thank you Craig.

Gillian

Okay Craig, thank you I will try it.

I am just trying to update a customer order field with a max invoice date from the invoice header. I didn't know...

Thank you too, you just saved me a whole rewrite of a program.

G

That worked great, thank you so very much.

G.

Thanks so much, I will give that a try right now.

Hi. The @Tmp table has only one field called sku. I want to read sku and link it to

the record called dbo.SFC_ItemURL on dbo.SFC_ItemURL.Item = sku...

Hi Scott.

I just wanted to tell you your code worked FANTASTICALLY!!! Thank you so much. I should buy you a big steak dinner! Have a super day.

Gillian

You're the MAN. I have to try it tomorrow. I can't connect from home to my work server. Waaaa. Hope you have an awesome evening and...

Thank you so very much Scott.

Gillian

Awesome SSS, you're great. Thanks so very, very much.

Gillian

Thank you so very much Doug. I will certainly do as you suggest from now one.

Thanks and have a wonderful evening.

Gillian

Thank you so very much Luis.

Gillian

Thanks so much for your response and help Scott.

I will try that too, but the #temp table that I need to update has already been grouped by Customer...

Thank you very much Doug. I will try it first thing in the morning and will let you know. I really appreciate your help. Thanks.

Gillian