how to add int Value

[getaccessyr]

Create PROCEDURE [dbo].[WidgetServer_GetAllShopList_FR] ( @CatalogID nvarchar(max), @PageSize INT, @PageIndex INT, @NoOfPages INT OUTPUT ) AS DECLARE @StartRowIndex INT DECLARE @Delimiter CHAR DECLARE @iIndex SMALLINT DECLARE @iCatalogId INT DECLARE @iNoofPages INT -- DECLARE @CatalogID nvarchar(max) --DECLARE @PageSize INT --DECLARE @PageIndex INT --DECLARE @NoOfPages INT -- SET @CatalogID='1,2,3'; -- SET @PageIndex = 1; -- Set @PageSize = 5; SET NOCOUNT ON; SET @StartRowIndex= ((@PageIndex * @PageSize) + 1); BEGIN SET @Delimiter = ',' WHILE @CatalogID <> '' BEGIN SET @iIndex = CHARINDEX(@Delimiter, @CatalogID) IF @iIndex > 0 BEGIN SET @iCatalogId = LEFT(@CatalogID, @iIndex-1) SET @CatalogID = RIGHT(@CatalogID, LEN(@CatalogID) - @iIndex) END ELSE BEGIN SET @iCatalogId = @CatalogID SET @CatalogID = '' END BEGIN SET @iNoofPages = (SELECT ISNULL((SELECT ((COUNT(*) / @Pagesize) + CASE WHEN (COUNT(*) % @Pagesize) > 0 THEN 1 ELSE 0 END) FROM dbo.Shops INNER JOIN Folder ON Folder.ShopID = Shops.ShopID INNER JOIN [Catalog] ON Catalog.CatalogID = Folder.CatalogID WHERE Catalog.CatalogID = (@iCatalogId) AND dbo.Shops.[Status] = 1),0)); END SELECT Distinct Shops.ShopName_FR as ShopName, Shops.ShopID,Catalog.CatalogID, Catalog.CatalogName_FR as CatalogName, Folder.FolderName_FR as Folder FROM Catalog INNER JOIN Folder ON Catalog.CatalogID = Folder.CatalogID INNER JOIN Shops ON Folder.ShopID = Shops.ShopID Where Catalog.CatalogID = (@iCatalogId) END END In this while looping first we will get NoofPages=4 and then 2 I need to add those to values and get in NoofPages Can any one tell me how? Yamuna

[Mycroft Holmes]

PLEASE use

tags when posting your code.

Are you trying to get the sum of noofpages?

Declare
@Var INT

Select @Var = SUM(case statement)
From ....

Print '@Var ' + Convert(varchar(1000),@Var)

[getaccessyr]

hi Thanks for your reply how can we get the NoofPages count here thru when case? explain in detail. regards, Yamuna

[Mycroft Holmes]

yamunarani wrote:

explain in detail.

The new snd codz plz Sorry if you cannot work it out then I can't help you.

Never underestimate the power of human stupidity RAH