using System;
using System.Collections.Generic;
using System.Text;

namespace MMDAL.Query.Excise
{
    public static class ExciseQB
    {
        public const string GET_SELECTLIST_EXCISE = @"
    WITH Excise AS
    (
        SELECT
            A.EXCISEID AS Id,
            A.EXCISENAME AS Name,
            ROW_NUMBER() OVER (ORDER BY A.EXCISEID) AS RowNum
        FROM TEXCISE A
    )
    SELECT
        Id,
        Name
    FROM Excise
    WHERE
        (@firstnumber = -1 AND @maxresult = -1)
        OR (RowNum BETWEEN @firstnumber AND @maxresult);";
    }
}