EMC Test Equipment

DECLARE @PageNumber AS INT, @RowspPage AS INT SET @PageNumber = 1 SET @RowspPage = 20 SELECT * FROM base_model INNER JOIN sub_model ON base_model.CBMD_BASE_MDL_NUMBER = sub_model.CBMD_BASE_MDL_NUMBER WHERE( base_model.CBMD_BASE_MDL_NUMBER IN (	SELECT base_model_category.CBMD_BASE_MDL_NUMBER	FROM base_model_category INNER JOIN sub_category ON base_model_category.MMCSC_SUB_CATEGORY_ID = sub_category.MMCSC_SUB_CATEGORY_ID AND base_model_category.DC_DIVISION_CODE = sub_category.DC_DIVISION_CODE WHERE (sub_category.MMCC_CATEGORY_ID = '316') 		AND (sub_category.MMCSC_SUB_CATEGORY_ID = '3073') AND (sub_category.DC_DIVISION_CODE = '1')	)) ORDER BY (CAST(CAST(sub_model.LIST_PRICE AS float) AS INT))DESC OFFSET ((@PageNumber - 1) * @RowspPage ) ROWS FETCH NEXT (@PageNumber * @RowspPage) ROWS ONLY