the best way to: SP B exec SP A where A returns value

[toLucky]

I got this:
-------------------------------------------------------------------------
CREATE PROCEDURE A
@Aoutput BIGINT OUTPUT
AS
BEGIN
SET @Aoutput = @Aoutput + 1
END
GO

CREATE PROCEDURE B
@Boutput BIGINT OUTPUT
AS
BEGIN
EXECUTE A @Boutput OUTPUT
END
GO

DECLARE @Ab AS BIGINT
SET @Ab = 3

EXECUTE B @Ab OUTPUT

PRINT @Ab
GO
DROP PROCEDURE A
DROP PROCEDURE B
GO
-------------------------------------------------------------------------

It works great, but cant you do something like:
-------------------------------------------------------------------------
CREATE PROCEDURE A
AS
BEGIN
RETURN 1
END
GO

CREATE PROCEDURE B
AS
BEGIN
DECLARE @B AS BIGINT
SET @B = 3
SET @B = @B + (EXECUTE A)
--AND THEN USE @B = 4 HERE
END
GO
-------------------------------------------------------------------------
Tnx to all in advance
toLucky

[azimmer]

I got this:
-------------------------------------------------------------------------
CREATE PROCEDURE A
@Aoutput BIGINT OUTPUT
AS
BEGIN
SET @Aoutput = @Aoutput + 1
END
GO

CREATE PROCEDURE B
@Boutput BIGINT OUTPUT
AS
BEGIN
EXECUTE A @Boutput OUTPUT
END
GO

DECLARE @Ab AS BIGINT
SET @Ab = 3

EXECUTE B @Ab OUTPUT

PRINT @Ab
GO
DROP PROCEDURE A
DROP PROCEDURE B
GO
-------------------------------------------------------------------------

It works great, but cant you do something like:
-------------------------------------------------------------------------
CREATE PROCEDURE A
AS
BEGIN
RETURN 1
END
GO

CREATE PROCEDURE B
AS
BEGIN
DECLARE @B AS BIGINT
SET @B = 3
SET @B = @B + (EXECUTE A)
--AND THEN USE @B = 4 HERE
END
GO
-------------------------------------------------------------------------
Tnx to all in advance
toLucky

You have a couple of choices:

1. Make A a FUNCTION instead of a PROCEDURE. (It's OK in your example but it has limitations in general; not that strict, though.)
2. Introduce a new variable in PROCEDURE B, such as @X, EXECUTE A against @X, then SET @B=@B+@X

Hope it helps.

[toLucky]

You have a couple of choices:

1. Make A a FUNCTION instead of a PROCEDURE. (It's OK in your example but it has limitations in general; not that strict, though.)
2. Introduce a new variable in PROCEDURE B, such as @X, EXECUTE A against @X, then SET @B=@B+@X

Hope it helps.

well I just deleted the "RETURN" and replaced it with "SELECT" - and now i can do what ever i want to :)
Your solution is ok tho :D