Excellent, thanks guys. Both ways look good to me - as I expand the problem into the real world, I'll assess which fits best.

Apologies if this is obvious, but you're not looking for a full duplicate. Just a duplicate...

Koen Verbeeck (6/22/2012)

---

My guess is that you have duplicate rows in your source.

The first row inserts fine but at the second row you get the unique key violation error.

When you...

As my Friday good-deed service to lazy people, here's that link again but with URL tags added:

Link here

If you'd rather avoid code, you might like to have a look at the Pause Task[/url] on CodePlex.

Everyone who fought the Nazis, including internal rebels within Germany, took risks. The article doesn't say "Americans beat the Nazis", it says people who took risks did that. And I...

Please detail what is wrong with Cold Coffee's solution.

IceDread (6/19/2012)

---

Phil Parkin (6/19/2012)

---

IceDread (6/19/2012)

---

Intelligence does not make you great. Some studies I read showed that if you had reached what you wanted or were content with what you had...

If you don't know what you want, what chance do we...

I think that some Canadians might have been involved too.:rolleyes:

IceDread (6/19/2012)

---

Intelligence does not make you great. Some studies I read showed that if you had reached what you wanted or were content with what you had you stop to...

Please provide sample data and sample desired results so that we can understand your requirements better.

Another possibility would be to write some code in Excel which adds the two 'group' columns (claim number and insured) to the table data & then throw away all non-data...

Maybe this article will help.

It shouldn't matter.

But check out DBCC CHECKIDENT RESEED in BOL if you are adamant that it must be changed.