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]

Read Jeff's article on DelimitedSplit8K[/url], which contains a download that has the complete DelimitedSplit8K code. (Read the article, and the link is... <should I tell?> ) Once you...

If you are using Windows authentication, then security is handled by Active Directory. You create users and then add them to Groups, and assign the permissions to the groups...

Good point! Especially if you use a pivot table or PowerPivot... but you need Excel 2010 or later for PowerPivot.