wow that is awesome.

Thank you so much.

Ok i have this working however I still don't understand how to get all the values when my select returns more than 1 row. I assume I need a loop...

Here is what im trying to do. Server A Table A has a table that has primary keys (PlantID, RuleType, RulePrefix, RuleSuffix) Same with Server B Table B. The only...

alright i was able to get it working.

One more question. What im trying to do is compare a column from serer B to Server error and return the rows that...

Thanks for the reply but i get the same error message with the syntax like that. Is there some other setting i need to change or something. Or is there...