Please explain what you mean by "hit that server remotely". Is this from within SQL Server? What is the purpose of this?

Np. And lucky you. The hardest part of everything I do in Azure seems...

This command won't work unless you have already authenticated with Azure somehow ... have you done that elsewhere in your code?

If you execute whatever is in @Cmd directly from the command line, does it work?

Here's a full set-up query, using temp tables instead of perms.

DROP TABLE IF EXISTS #RailCarCycle;

CREATE TABLE #RailCarCycle
(
    ID INT IDENTITY(1, 1) NOT NULL PRIMARY...

• This reply was modified 6 years, 10 months ago by Phil Parkin.

What is required is the DDL for RailCarCycleYard, along with INSERT statements to generate sample data there.

Then I will be able to run and adjust your query myself ...

the Identity column is not col1 thru col4, it is col12

I am just trying to insert from table1 to table2 (with a unique index) but i get duplicate errors...

What is your question?

I cannot cut & paste from your post into SSMS in order to create sample tables containing sample data.

If I could do this, I (or someone else) would be in...

Please check this post for an example of how you need to post your question in order to get a working solution in response.

Without sample data, I can't provide a solution.

But I can suggest an approach. Build a subquery which selects only those rows which satisfy your criteria and then

INSERT...

So you are asking us to invent lies for you? Sorry, but I won't do that and I doubt that Sue will either.

Have some professional integrity and tell the truth...

With that much experience, you should already have encountered plenty of relevant technical and organisational issues as part of your work. Go ahead and use those!

If I Google that error, there are a lot of hits. Have you tried following some of the suggested resolutions?

Here's a quick solution. There are more elegant ways of getting there, but I'm a little short of time.

DROP TABLE IF EXISTS #t1;

CREATE TABLE #t1
(
  ...