I want to know the value of @NoOfDaysForDelayApproval in a print syntax, but it is not displaying it.
declare @NoOfDaysForDelayApproval int
BEGIN select @NoOfDaysForDelayApproval = sum(Total_Days)
from XXACL_EMP_DELAY_APPROVAL_V
where cardno=@EmpCardNo
and DMonth= @Month
and DYear = @Year
print 'delayed :- ' + convert(varchar(50), @NoOfDaysForDelayApproval)
END
even delayed is not getting print.
I am using SQL-server-2005
Aucun commentaire:
Enregistrer un commentaire