{RESOLVED}Stored Procedure OUTPUT

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

{RESOLVED}Stored Procedure OUTPUT

Author

Topic

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-03-04 : 18:44:49

I resolve this by doing the following
SELECT @t = @a + ( @b * (1 + @SQRT ) / @d)

SET @TotalRequiredTime = @t/60

Greetings

I haev been on this stored procedure for whole day, even skipped lunch, just remembered I did not eat. So believe me when I say I haev read every post about OUTPUT and am unable to solve my PROC. It keeps returning NULL. When I debug it manually meaning run the content of proc with static parm I set the result is fine.

CREATE PROC [dbo].[usp_GetTotalRequiredTime]
(
@BranchID INT,
@CommodityID INT,
@Gauge FLOAT,
@OrderedPieces FLOAT,
@FinalWidth FLOAT,
@FinalLength FLOAT,
@ShipDate AS DATETIME,
@TotalRequiredTime INT OUTPUT
)
AS
BEGIN
--Calculations
/* T = m/µ + [ (3.54) * s^2 (1 + Sqrt[4µm/3.54*s^2 + 1]) ]/ 2µ^2 */
SELECT @TotalRequiredTime = @a + ( @b * (1 + @SQRT ) / @d)
END
Brain freeze , what in the world am I doing wrong?
I get following error:
Warning: Null value is eliminated by an aggregate or other SET operation.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources