Conversion failed converting the varchar value '' to int

Question

DECLARE @temp TABLE (Id varchar(MAX) NOT NULL, name varchar(MAX) NOT NULL ,itemtype varchar(50) NOT NULL );
INSERT @temp (Id,name,itemtype)
SELECT distinct STUFF((SELECT ',' + Item.Id FROM Items Item
INNER JOIN ProductDetails on Item.Id=ProductDetails.ItemsId
where Item.BrandsId in (select id from Brands) FOR XML PATH('')),1,1,'') AS ID,Item.ItemName,'Item' FROM Items AS Item
GROUP BY Item.ItemName

Select * from @temp

Manas Mohapatra · Answer

Use query like below: DECLARE @temp TABLE (Id varchar(MAX) NOT NULL name varchar(MAX) NOT NULL itemtype varchar(50) NOT NULL ); INSERT @temp (Idnameitemtype) SELECT distinct STUFF((SELECT '' + cast(Item.Id as varchar(max)) FROM Items Item INNER JOIN ProductDetails on Item.Id=ProductDetails.ItemsId where Item.BrandsId in (select id from Brands) FOR XML PATH(''))11'') AS ID Item.ItemName 'Item' FROM Items AS Item GROUP BY Item.ItemName

Manas Mohapatra · Answer

You are getting result as per your query. I am not sure about  256238924 . You can change your logic and see the result.

Mani Kandan · Answer

Thank you for replay me sir Using this query I got result like this:- Id= 123445679101112121314151617181920 etc... and name is not showing alphabetically But I want result like this Id =256238924 that is Id is respect to name with not repeat same name

Conversion failed converting the varchar value ',' to int