Agreed.  And maybe post some output or desired output...

I think(?) you want CONVERT( varchar(#), ESTCIPWK) AS esweeks.  # is the number of characters you need. 

Try that and we'll see.... 

I do not know if the double quotes are used to show us the format or if they are actually passed into SQL Server.  If you can replace them with...

Yes.  If you will note, I used ServerName and dbname (database name) and TableA and called one DEV and one PROD.  You can specify whatever names you need.  This is...

This might help... I am comparing between Development and Production as an example...

SELECT DEV.IdentityField AS 'Dev IdentityField',

             PROD.IdentityField AS 'Prod IdentityField',

-- other fields

FROM TableA DEV

    ...

This should work.  I tried testing it with my own data, so it is hard to know what is in your tables....  I do have difficulty understanding the OR; I...

Frank Kalis gave me some code off-line that might help.  I am rather thick-skulled, so he had to give two versions - the use of modulo made more sense to...

This one was really bugging me, so I put a bit of effort into it.  It may be all worthless if Remi's answer worked. 

Its always easier to change things in one place.  But, if trying to get this approach to work becomes too cumbersome, you can always copy it to other servers.  Great...

This is way over simplified, but it 'might' get you moving in a direction that will help - hope so....  I am assuming you have a table named States for...

I'd suggest two things: 

1. make sure #mat_sample has already been created. 

2. The parenthesis generally are used to name the specific fields within the table, (in this case, #mata-sample)...

Boy, folks on this site hate hearing this, (and for valid reason) but you may want to try Dynamic SQL.  Since you obviously know how to jump servers, you could...

You might want to try using SELECT @@SERVERNAME with flow control to make sure your processes are working only on the server you desire. 

Thanks.  We'll have to see if it works for AJ, though... 

  Nothing..., it worked for me. 

What do you see that is wrong?