Works In Query Analyzer But Not In SP

Hi I have a following SP that does not return results. Could somebody tell me what I am doing wrong here.








CREATE procedure dbo.wfiDocuments_Get


(


@ModuleIdint,


@PortalIdint,


@IsActivebit=NULL


)





AS





declare @SQL nvarchar(4000)





SET @SQL =


'select


DocumentId,


ModuleId,


PortalId,


CreatedByUserId,


''CreatedByUserName'' = Users.FirstName +'' '' + Users.LastName,


CreatedDate,


Title,


Category,


Syndicate,


Clicks,


Size,


Description,


FileName,


VPath,


IsActive


from wfiDocuments


left outer join Users on wfiDocuments.CreatedByUserId = Users.UserId


where PortalId=@Portal and ModuleId =@Module'








IF @IsActive IS NOT NULL


SET @SQL = @SQL + ' AND IsActive=@Active'





SET @SQL = @SQL + ' ORDER BY Title'





EXEC sp_executesql @SQL,


N'@Portal INT,@Module INT,@Active bit',


@PortalId,@ModuleId,@IsActive


GO