michael vessey (5/18/2012)

---

HowardW (5/18/2012)

---

AlAndrew (5/18/2012)

---

michael vessey (5/18/2012)

---

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from...

michael vessey (5/18/2012)

---

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from table_2 where userid=x.userid and...

Wonderful addition to my reporting. Easy to install and use. Thanks for sharing!

Worked like a charm!

Thanks!

la4rha,

The "SET NoCount ON" works like a charm! Thanks for the help.

-Al

Thanks Guarddata.

I'll fire up QA and see what type of results I can come up with.

Yes, I am using ADO.

How can I cycle(loop) through the records inside the SP itself? Is that possible?

Yes I have. Here's what I have going on:

I'm calling a Stored Proc from an .asp app. This is what is in the SP...

Create Table #CashIn (WarrantyNumber varchar(30),...

Never bothered to look into DTS. Just assumed it was for tables only. Worked out great. Thanks.

Awesome. Works like a charm. Thanks for your help.

I know this is bad practice, but if I create a non-clustered index will it still change the order?

That's great news. Thanks Clive.

Thanks Steve. After reading your articles, we've decided to handle number incrementing on our own through our interfaces. Although this is not a huge 'bug', it's one I...