micheal.vel Member Member since Feb 25, 2011 Last active Feb 25, 2011 Total activities 0 Activity feed Recent contributions #Threads 15 years ago 927814aa-c5e8-44f9-a901-0d279cba8c7e hi friends.............. Hi HEART_HACKER, you want to declare the out param and then execute. declare @DepName char(50)output; begin EXEC prcGET...