Thanks everyone for your help! This helped me a great deal, i was able to set my parameter to the result value. Thanks again!

Thanks for the link. I tried it out but it's still not returning the value back into my variable.

But the table is replicated. And the column is part of a primary key. Any easy way to do this?