No... number of rows. For example, if you have a table of names, if the insert has names that start with every letter of the alphabet, that would be...

See? Pork chops RULE!

Ahmad Osama (10/7/2008)

---

The answer is... whichever one that implies a temporal order for when the inserts occurred. In other words, either an IDENTITY column or some temporal column such...

OMG! I'm clutching my sides with tears...

BWAA-HAA! Did you leave any redmarks on your cheeks from the slingshot kickback? :hehe:

Almost perfect... well done. Now, lemme ask you a question... what do you think will happen when the year in your data changes? 😉

Ah crud... my fault... that's what I get for posting without being under the influence of coffee.

Lemme see what I can do about this... haven't had to do it in...

I agree with Jack... the best way for you to learn this one is to try it on your own, first. Read about "Triggers" and the "INSERTED/DELETED" tables that...

Lynn Pettis (10/7/2008)

---

Jeff Moden (10/7/2008)

---

Heh... what an idea... maybe I'll title it "Porkslinger: Have Chops, Will...

J (10/7/2008)

---

Another use.

Generating Universal Product Code numbers.

UPC-12 is PPPPPP-NNNNN-C (hyphens added for clarity)

P: 6 digit company prefix assigned by EAN Council

N: 5 digit sequential number

C: check digit, based on modulo-10...

:P;)

TenDayIT...

As it turns out, your original code had the same flaw as the modified code... bad Dynamic SQL if more than 1 parameter is provided.

I can help, but I need...

Your new proc delivers bad SQL if more than one input parameter is provided... here's what the Dynamic SQL it creates looks like when...

Heh... I recognize that, Clint. And, I'm not being evasive about code. I just recognize that you're both intelligent as well as being a bit new to SQL....

Heh... now that I...