using System;

namespace AnalyticsDAL.Query.Dimension
{
    public static class DimensionQB
    {
        public const string GET_DIMENSION_SELECTLIST = @"

WITH PagedDimension AS (
    SELECT
        A.DIMENSIONID AS Id,
        A.DIMENSIONCODE AS Code,
        A.DIMENSIONNAME AS Name,
        ROW_NUMBER() OVER (ORDER BY A.DIMENSIONID) AS RowNum
    FROM MDIMENSION A
)
SELECT
    Id,
    Code,
    Name
FROM PagedDimension
WHERE
    (@firstnumber = -1 AND @maxresult = -1)
    OR
    (RowNum BETWEEN (@firstnumber + 1) AND (@firstnumber + @maxresult));";
    }
}