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.

Just out of interest, how are you going to keep the EmplIds in sync? Seems like there might be more to this than just syncing e-mail addresses.

Can both systems update...

I've never been brave enough to try that option out, just in case something got 'upgraded' inadvertently 🙂

Try using an OLE DB\SQL Native Client connection instead.

Please post the full text of the error message you are receiving.

And I quite like Consolas because that's what Visual Studio uses. Not sure that you'll get a consensus here. But I do agree with Anthony about the colours - I...

I like happy endings, good work 🙂