CSV file attached.

First column = id

Second column = controlnumber

Third column = endno

Craig Farrell (10/8/2010)

---

I had assumed, since 2k5 and 2k don't behave, but figured it was worth the question. I'm sure Wayne and the others will be able to get...

Craig Farrell (10/8/2010)

---

It would appear the...

Craig Farrell (10/8/2010)

---

craig-404139 (10/8/2010)

---

Sure. I was also thinking would this be easier if I added a PK to the table? Both of these columns are just data columns in my...

Craig Farrell (10/8/2010)

---

craig-404139 (10/8/2010)

---

Craig Farrell (10/8/2010)

---

Sorry guys, came down with a case of the plague yesterday, didn't mean to abandon the topic. Was looking through the code and Craig-4...

Craig Farrell (10/8/2010)

---

Sorry guys, came down with a case of the plague yesterday, didn't mean to abandon the topic. Was looking through the code and Craig-4 (we're gonna need...

WayneS (10/7/2010)

---

Craig,

I'm having problems loading this much data into a sample table. Can I get you to export the data into a new table in a new database? Detach the...

Odd, The numbers are correct, it just inserted 13 null rows for some reason. I updated the zip.

WayneS (10/7/2010)

---

Here's some code.

Note that I kept in the prefix checking... I need to strip it out anyway, so I just kept it in.

-- need to add some columns to...

WayneS (10/7/2010)

---

craig-404139 (10/7/2010)

---

I see you added columns to the table, Can this be done without adding columns? I can't modify my production table(s). Also explains why the are like that....

Wow, impressive. Can you explain what the code is doing? I've never seen things like :

@GroupNo = GroupNo = case....

@Prefix = Prefix = LEFT.....

Looks like you are setting the variable,...

WayneS (10/7/2010)

---

It's actually post # 1000643. Also, if you click the post number, you will get a URL that you...

Ok. Because of this time crunch and my frustration with this, let's try this a different way. I need to compare the controlnumber to the endno and find the...

Thanks for the help guys, but I am 100% lost AND my requirements just changed. FML. I will update soon with new test data (if I don't pill my hair...

WayneS (10/7/2010)

---

k from the OP...