Dynamic SQL. Interesting solution, thank you.

Thanks Sean. I didn't know anything about CDC so I looked at http://technet.microsoft.com/en-us/sqlserver/gg313769.aspx.

It cannot be implemented in the environment now but it was interesting. Thank you.

Thanks for your reply. I reviewed permissions and found that SQL Server login account did not have access to the full path, I had applied proper access to the final...

Hi MM, thank you for your reply. I did try specifying all column names in both SELECTs but I got the same error. That's why I figured I would have...

Thank you, I guess I will just have to loop through the source one at a time.

I took out the PARTITION BY name and it worked. Thank you.

The result was every row number as 1 when I used the example code of

SELECT [RN] = Row_number() OVER (PARTITION BY NAME ORDER BY NAME)

...

Thank you Nate. I don't know where my brain is today:-), that will do just fine.

Thank you both. I have never done anything with XML in TSQL. With these working solutions I will be able to learn a bit more. Thank you.

Wonderful, thank you. This is the next which I apparently didn't right either. Would you tell me what I have wrong please.

create table xmlMWR (SSN varchar(9), TaxableWages varchar(20))

INSERT INTO...

Sorry to bother, I went to BOL and found a parameter @query_result_header. That took care of the problem.

Thank you.

Hi Lynn, if someone someday changes the name of the job my procedure would break. Where do I find the job_id? It is less likely that someone will delete the...

Yes, thank you.

Hi Lynn, I get the following error:

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.sp_start_job'. The stored procedure will still be created;...