<pre> ;WITH CTECostCentre AS ( SELECT *,COUNT(t1.CostCentreID) OVER() COUNT FROM ( SELECT ROW_NUMBER() OVER (ORDER BY CASE WHEN SortType = 'DESC' THEN CASE WHEN SortExpression = 'CategoryName' THEN CategoryName END END DESC ) AS ROW,te FROM categorymaster C WHERE ( (IsSearchByText = 1 AND (SearchText IS NULL OR LEN(SearchText)=0) OR REPLACE(C.CostCentreName, ' ', '') LIKE '%' + REPLACE(SearchText,' ','') + '%' OR REPLACE(CG.CategoryName, ' ', '') LIKE '%' + REPLACE(SearchText,' ','') + '%' ) ) ) AS t1 ) SELECT * FROM CTECostCentre WHERE ROW BETWEEN FromIndex AND ToIndex </pre>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)