Out Parameter Value Is NULL

I Created a Procedure that Generates an ID value based in the current Date (Year/Month) and a value which are stored in a table. This ID value is update in the table, and passed on to an output parameter as folows:





Code Snippet




CREATE PROCEDURE [dbo].[CNSPGetNewGuideID]
@SectionID bigint
,@Year bigint
,@Month bigint
,@ID bigint output
AS
BEGIN




(...)

SELECT @ID = [Year]* 10000000 + [Month] * 100000 + [Number]
FROM [dbo].[CNGuideID]
WHERE [Year] = @Year
AND [Month] = @Month





print 'New ID : '
print @ID
END


This is working and the value printed here is the correct one.

but when I execute the procedure inside another one, the variable i pass on as an output parameter remains NULL...





Code Snippet




CREATE PROCEDURE [dbo].[CNSPInsertNewGuide]
@SectionID int
,@ClientID int
,@UsuaryID bigint
,@UsuarySectionID int
,@ID int OUTPUT
AS
BEGIN

DECLARE @Date as datetime
DECLARE @Year as int
DECLARE @Month as int

SET @Date = GetDate()
SET @Year = YEAR(@Date)
SET @Month = MONTH(@Date)

EXEC CNSPGetNewGuideID @sectionID,@Year,@month,@ID

(...)




I also tried just declaring a variable and executing the procedure but the same thing happens





Code Snippet
declare @ID2 bigint


EXEC CNSPGetNewGuideID 06,2008,03, @ID2

print 'ID : '
print @ID2




this is the result I get:

New ID :
20080300030
ID :

I must be missing something...
Can anyone help?

thanks.