Hi John,
Thanks for the reply,
But I want to excute this SP Step by Step,
And If in any one of the SP error comes then next one should be executed.
Execute Mis_SP_Earn_PJ_Mast_Extraction 'Earn_PJMast_201211','30-Nov-2012'
EXECUTE Earn_Tran_Extraction '[UNO-III\HISTORY].MIS.DBO.Earn_PJMast_201211', 'Earn_PJTran_201211','12-Dec-2012'
EXECUTE Earn_Actual_IRR 'Earn_PJMast_201211','Earn_PJTran_201211'
Can You please provide the steps or link to do the same
Thanks in Advance!