Apologies for not taking the time to read your original post thoroughly enough!

Can you not emulate exactly what the...

Why not use an IDENTITY column for this?

Or create a SEQUENCE and use that.

What are you displaying this in? Excel/SSRS and similar tools offer formatting options to take care of this for you.

SSMS is a query tool, not a presentation tool.

Is this what you're trying to do?

INSERT #RailCarCycle
(
    RailcarID
   ,StartDate
   ,StatusID
)
SELECT rccy.RailcarID
      ,rccy.LoadDate
  ...

My response was based on this comment by you:

I do have a work around,...

I do have a work around, from server S3 i am using a execute SQL task and passing net use along with user name and password, there on all the...

• This reply was modified 6 years, 4 months ago by Phil Parkin. Reason: Fix typo

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, 4 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...