报表日期参数

alter PROCEDURE A01_Test
    @docno nvarchar(max)='',
    @CreatedOn nvarchar(max)
AS
BEGIN
    SET @docno= N'and '+ REPLACE(@docno, 'docno', 'docno');

    if(ISNULL(@CreatedOn,'')!='')
    begin
    SET @CreatedOn=N'and ' + REPLACE(@CreatedOn,'createdon','cast(CreatedOn AS DATE)');
    end

    DECLARE @SQL nvarchar(max);
    SET @SQL='select docno,CreatedOn,DescFlexField_PrivateDescSeg4 from MO_MO WHERE 1=1 ';

    print(@SQL+@docno+@CreatedOn)
    EXEC(@SQL+@docno+@CreatedOn)
end