The number of address lines is unknown for any customer. it is 1 to n and while typically is 4 or less can be more. I also wanted to extend...

/*
Ok, Here is the revision. I have a few things,
1) to pivot and join the results,
2) to rename columns in the pivot.
3) Make this callable so...

Thanks, I will work on that. the pivot query has a few problems that I just found out. Once I correct that I will repost.

Great thanks. I haven't done SSIS in a few years but it shouldn't be that hard.

It's about master data. It is a similar format to the target system. Unfortunately the source systems are in multiple formats and I need to get to a single format...

Problem solved. There were 3 additional accounts in AX that may have been making a call to MDS and those had to be added via the website security.

Thanks a bunch! One can never have too many tools in the toolbox

I would just use the entire string in the city field. I could possibly also read up to a comma in the field as in Springfield, MO. I was also...

Is it possible to turn this around and get city names  as a substring that are not in my database at all?

Thanks a bunch. I think I am good, this gives me a better look than I had before. Some of these will need to be eyeballed anyway so having a...

That does work except I will get 2 results for that one. I have both New Dehli and Dehli as cities which are both in my city list for India....

This is not working with the % but it does work without it. 

SELECT   ,[Name]  ,[Address]  ,[Address2]  ,c.[City]  ,r.[city_name]  ,[State]  ,[ZipCode]  ,[TerritoryCode]  ,[CountryCode]
FROM [Customer] c
left...

I figured performance would be sluggish. 
This isn't a regular production run. We are moving data to a new system and would like to clean some stuff up. The legacy...