Hemin,

There's another way to do the same thing that's actually much faster if you have a large table you need to do this on. It, too, is covered in...

Heh... I'm getting closer... normally, you beat me to this on providing solutions. ...

hemin.shah85 (1/23/2009)

---

Jeff tons of thanks for this solution. It works perfect for my data. I would definately like to know logic behind this if you can throw some light on...

tony.hayes (1/23/2009)

---

If it was a simple mail merge that might be possible, but we produce custom legal certificates in house on z-fold self seal documents, as well as W2's etc......

Thanks, Tony... lemme see what I can do.

Like I said... just a little of 2.8 GB... I've got files much larger than that.

I've been through that with 2 companies now... they ignore the flagship product that...

tony.hayes (1/23/2009)

---

Sorry, first post ever. The only way I could get the data electronically was to copy from where USPS had posted to their website. An example of...

Not trying to be a smart guy here... just...

RBarryYoung (1/13/2009)

---

Abhijit More (1/13/2009)

---

there is another way which you can use..

1. Take the MAX(userID) before batch insert. this will give you the last UserID before batch insert

2. Perform batch insert.

3....

bagofbirds (1/8/2009)

---

Fantastic. Thanks for everyone who took the time to think about, and reply to, my question. Thanks especially to RBarryYoung who's solution elegantly solves the whole problem....

Ray M (1/23/2009)

---

Your not giving us enough information.

How do we know which row is the first row?

The one with the value or the one that is blank.

Do you have an...

Actually... good post... I get it. To make future posts just absolutely perfect, take a look at the link in my signature below... THAT's how we like to see...

David's recommendation is pretty much, spot on. Since you're a newbie at this, you may want to visit W3Schools.com and learn how to join tables without creating an alias...

Not to be contrary, but I like option 2. That way, you wouldn't have to worry so much about doing individual grants or accidently doing a grant on a...

Here ya go, Tony... lemme know how this works for ya... compete with test code... of course, you need to create the Tally table first, but you've got a...