Are the two datasets based on the same tables?

If they are, you could create a calculated column in your dataset that groups the "1-4" records together and the "5" records...

What version of SQL Server are you using? If you're using something post-2012(?), you have to download and install SQL Server Data Tools (used to be BIDS)... that enables you...

One option might be to use the bastard child of SQL Server - Access... (bear with me for a minute)....

Create a table in Access of (source column name, destination column...

It seems you are misunderstanding what SQL Server does with empty space in a table... It does nothing unless you tell it to.

Executing DELETE statements against a table...

To what entity to the e-mail, address, and phone number belong? Presumably a person. A student? They certainly don't look like they belong in the Fact table at...

Seriously? All of these follow a similar pattern... this one:

SELECT DISTINCT field1, field2

FROM SourceTable;

Boggles my mind you could ask a reasonably complicated question and then trip up on the part...

Could you post your code? Not sure why you have ot itereate over the results and do something... trying to figure out a way to avoid using a cursor.

INSERT INTO MyNewTable(ColumnList)

SELECT ExpressionList

FROM OldTable

?

Could you post your create table scripts and some sample data? It sounds like you have to unpack the intervals and then compare, but I'm not sure without table...

Oh, you neglected to mention that it was a vendor database. Key piece of information.

having said that, the only way I can think of helping this situation out is to...

Is there any way you can split this part of the data into a separate column?

convert(nvarchar,keyvalue) like '%11857548%'

Ideally, you'd want the 11857548 value in a column by itself so you...

Mike,

Why do you need a cursor for this? Can't you just do a basic upsert? Here's some fun reading for you:

An UPSERT example from Paul White

Please define "depth level".

Sounds like this is a great candidate for SSRS.

If you were going to automate this, wouldn't it require at least a one-way trust between the two domains? SneakerNet isn't really automation...

What version/edition of SQL Server are you running?

You could use PowerShell...

Tim Smith

Automating Flat File Imports Using Powershell[/url]