Jeff,

Could you do it in SQL 2000 with a tally table and derived tables?

😎

Here is my updated code:

set nocount on

create table dbo.StatuteHistory (

StatuteId int,

WeightEffectiveDate datetime,

Weight int,

primary key...

You could also do something like this in SQL Server 2005/2008:

set nocount on

create table dbo.StatuteHistory (

StatuteId int,

WeightEffectiveDate datetime,

Weight...

Brandie,

Still working on the basic flow. Regarding the data scriub, once you have done everything possible programmatically, questionable and bad matches should go to an error report and back...

Manie,

If you create new numbers for the company being merged, do you keep a cross-reference table so you can map the old numbers to new? You still need to...

Matt, You're being modest!

😎

Manie,

Your code >>

select @nextinvoice = [next invoice number] from company

update company set [next invoice number] = isnull([next invoice number],0)+1

How I would change it >>

update dbo.company set

[next...

I also have to agree with Matt. But back to my last post, getting an idea of the data flow with perfect data should also help identify how things...

I'm still working through what you are trying to accomplish, but to give you an idea of how I am approaching this I thought I should make a quick post.

I...

I added a second MSDB entry to your file. You will need to edit it as appropriate. After replacing this and restarting IS, when you attach IS to...

We have a development server running two instances of SQL Server 2005, a default instance and a named instance. I just modified the MsDtsSrvr.ini.xml file to show the msdb...

I actually like case sensitive collations. Forces accuracy in your scripts. Column names in system views in SQL Server 2005 are all lower case, so that's how I...

Matt, Online? Which one?

😎

I liked the D&D reference too (played it a lot in my younger days!)

😎

Matt,

I'll look at it. I found another link to MSDN (haven't the foggest how, but did it through BOL somehow) that may also help.

Lynn

😎