Hello,

How can I achieve the following?

Have a batch file that will get executed from a stored procedure using
xp_cmdshell.
The batch file will call another stored procedure using OSQL.
The stored procedure (after its processed the data) returns a number.
Further process flow in the batch file will depend on the value of the above
number.
How can I trap the return value from the stored procedure in the batch file?

Cheers!
SQLCatZ

Sorry!
This is in the wrong section.
SQLCatZ