Not sure if it is in BOL, but if you want the SQL Server 2000 statistics updated correctly, then yes, you need to do it with a full scan.

IIRC, this...

Kiara (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Nope, too much fun watching now. I can even answer his question on why he keeps getting the same value for @qtd on...

Based on the sample data, what is your expected result?

Nope, too much fun watching now. I can even answer his question on why he keeps getting the same value for @qtd on subsequent runs through...

Have to add a thanks. You did very good posting your first question. There are others out there that could learn from you.

Jan Van der Eecken (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

capn.hector (4/24/2012)

---

The Dixie Flatline (4/24/2012)

---

I'm getting a smile this morning just from hearing about a train wreck in the distance. ...

paul.knibbs (4/24/2012)

---

To be fair here, this is already the case for tobacco and alcohol, both...

First, your procedure can be rewritten to work without using a loop.

Second, how are you executing the procedure?

First, why are they using cursors? Second, what does it buy them to keep them open?

Table variables have their uses.

They can be the target of an OUTPUT clause of an INSERT, UPDATE, or DELETE.

They can be used to capture audit data that needs to be...

Lynn Pettis (4/24/2012)

---

capn.hector (4/24/2012)

---

The Dixie Flatline (4/24/2012)

---

I'm getting a smile this morning just from hearing about a train wreck in the distance. They are much more fun...

capn.hector (4/24/2012)

---

The Dixie Flatline (4/24/2012)

---

I'm getting a smile this morning just from hearing about a train wreck in the distance. They are much more fun when you...

The Dixie Flatline (4/24/2012)

---

I'm getting a smile this morning just from hearing about a train wreck in the distance. They are much more fun when you don't...

You can find more of the code here: http://www.sqlservercentral.com/Forums/Topic1286816-392-1.aspx#bm1288517.

The code above is an excerpt from the code in the other thread.

Instead of fragmenting your questions all over the place, why...

SQLKnowItAll (4/24/2012)

---

MyDoggieJessie (4/24/2012)

---

I knew I should have completely finished my first cup of coffee for the morning before posting this 😀

Issue resolved (walking away with tail between my legs in...