Hi Lowell,

Thanks again for this great start! Another question how do you format your replies in the scroll box like that?

Regards,

blawrence

Great help! Thanks...but I'm still getting errors. note below.

/****Is the syntax and structure correct?

Also, ‘DestinationDatabase.dbo.prempl.fempno’ has up to only four digits I need to remove all prefixed ‘0’s from the...

Real Example:

LINKED SERVER

SQLSERVER.SOURCEDataBase.dbo.Employee_Master

,[Empno] char(9)

,[Surname] char(30)

,[GivenName] ...

My apology for cross posting in the forum…won’t happen again.

Using MS SQL 2005.

I linked Database 'HR' to Database 'Production' via SQL Server Object Explorer> Objects > Linked Servers.

The script in need I mentioned is a required activity that will...

Very nice. Thank you for you time, effort and input.

Blair

___________________________________________________________________

amicitia est nobility

Your code worked perfectly when isolated outside of the Variable Table.

Thank you again for your time and input.

Blair

_______________________________________________________________

amicitia est nobility

I am using SQL 2005.

Here are the errors:

Msg 4104, Level 16, State 1, Line 21

The multi-part identifier "inboms.fcomponent" could not be bound.

Msg 4104, Level 16, State 1, Line 21

The multi-part...

You are correct. I do need the last transaction for each component. However which ever way I run this code it appears as though the CTE terminator (;) throws an...