When running the following stored procedure within SQL Server I get no data.

ALTER PROCEDURE dbo.sProc_TotalProjBudgAmt

@TotalProjBudgAmt decimal(38, 2) OUTPUT

AS
BEGIN


SELECT @TotalProjBudgAmt = SUM(P.projBudgAmt)
FROM dbo.tbl_Projects P

END

If I run just the select statement as follows, I get my total project budg amount.

SELECT SUM(P.projBudgAmt) AS TotalBudgAmt
FROM dbo.tbl_Projects P

There is no Input Parameter. I just want the output parameter as a total of the budget amount. What am I missing in the code? It's just giving me 0 rows? Once I know I can produce data, then I'll call it in my xmod pro. Any help would be appreciative.