assign sp result to a variable

[piti]

hi
i have stored procedure without parameters and i need to assign the result of this procedure to a variable in a script/another sp
using
exec @var = sp_name
returns, as it should, the return code, and i just can't figure out a solution how to assign the sp result to the variable
i can't change the sp
1. to have an output var
2. to set the result as a return code
so if somebody knows how to do that please help
thanx

 

[TheBugSlayer]

Here is an example with an output variable.

CREATE PROCEDURE usp_TARND_TURNAROUNDDATE @TADate VARCHAR(10) OUTPUT, @RecDate VARCHAR(10) = '12/22/2004',
       @TurnAroundDays INT = 2
--Created by XXXX on 2004-06-11 12:26:04.767
AS
DECLARE @TADays INT

SET @TADate = @RecDate
SET @TADays = @TurnAroundDays
WHILE @TADays > 0 BEGIN
    SET @TADate = CONVERT(VARCHAR(10), DATEADD(d, 1, CONVERT(DATETIME, @TADate)), 101)
    IF (SELECT COUNT(FDate) FROM T_TARND_DAYSOFYEAR WHERE FDate = @TADate AND FType <> 1) = 0
       SET @TADays = @TADays - 1   	
END

GO


DECLARE @D VARCHAR(10)
DECLARE @O VARCHAR(10)
SET @D = '09/05/2004'
EXEC usp_TARND_TURNAROUNDDATE @O OUTPUT, @D
PRINT @O

Let me know if you want an option 2 example.

 

[piti]

as i said, the sp is without variables and i can't add a new output variable ;-)