Electrical & Industrial 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.AMM_MFG_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.DC_DIVISION_CODE='1') AND (sub_category.MMCC_CATEGORY_ID = '304')  ) )  ORDER BY (CAST(CAST(sub_model.LIST_PRICE AS float) AS INT))DESC OFFSET ((@PageNumber - 1) * @RowspPage ) ROWS FETCH NEXT (@PageNumber * @RowspPage) ROWS ONLY