Hi Bob,

Thank you again for you help. All is working well.

Regards,

Blair

In doing so do I continue with the convert functions in the joins?

Regarding the trucation and this statement:

SELECT

Employee_Master.Empno,

I'm not following you. Could you please show me how and where in the query I would place this reference?

Regards,

Blair

Everthing worked correctly and transfered the data.

I changed the: INNER JOIN to: LEFT OUTER JOIN except it did not truncate the prefixed zeros from the source employee numbers.SQLSERVER.SourceDatabase.dbo.Employee_Master.Empno

...

Hi Lowell,

Please follow this link and let me know what you think is the best plan of attack.

http://www.sqlservercentral.com/Forums/Topic805941-338-1.aspx#bm806666

Regards,

blawrence

Is it possible that this is the issue:

FROM SQLSERVER.SourceDatabase.dbo.Employee_Master Employee_Master

INNER JOIN DestinationDatabase.dbo.Prempl Prempl ON CONVERT(int,Employee_Master.Empno) = Convert(int,Prempl.fempno)

WHERE Prempl.fempno IS NULL

What this was designed to do was grab employee numbers...

What is the architecture of a temp table in this situation? Could you provide an explaination using the data provided?

Regards,

blawrence

performance on the base query is fast (less then one sec.,) against aprox 600 rows of data from the source database and aprox 400 in the destination...if it is working...still...

Hi Lowell,

All is perfection!

Thank you again and again, you have been an amazing help through this endeavor. You have been crystal clear in your explanations. Thank you again for opening...

In this example it appears as though you are explicitly selecting the substrings in code. How do I select unknown strings from the existing source table [Code]LinkedServer.SourceDatabase.Employee_Master.BasicEarnGL[/Code] and use the...

Hi again Lowell,

I have not tried this yet?

[Code]/*INSERT INTO [DestinationDatabase].[dbo].[prempl]

([fempno],

[fname],

[ffname],

[fmi],

[fbirthdate],

[fcity],

[fdept],

[fendate],

[fnshift],

[fpaytype],

...

Error on this line of code. I have tried many variations...just not getting it.

Msg 102, Level 15, State 1, Line 8

Incorrect syntax near '='.

[Code]MyLinkedServer.PhoneNumber2 = [fphone] [/Code]

Error in my previous...

Hi Lowell,

Thank you very much for your amazing help and willingness to explain.

Cheers,

blawrence

Hi Lowell,

In this example you provided, I do not understand how, for instance ‘A’ becomes the default insert value for column [fmi] using an AS statement? I thought AS was...

Thankyou very much for your help so far... but the voyage continues.

My apology for not articulating the requirement in proper detail. I need to remove the leading zeros from the...