Hi! I used this code:
SELECT * FROM FruitTable
SELECT * FROM SecondTable
DECLARE @PersonId INT
SET @PersonId = 1
DECLARE @FruitIds VARCHAR(50)
SELECT @FruitIds = FruitId FROM SecondTable WHERE Id = @PersonId
SELECT @PersonId as 'Id',STUFF((SELECT ',' + Fruit FROM
(
SELECT CONVERT(VARCHAR,@PersonId) as PersonId,* FROM FruitTable WHERE Id IN (SELECT CAST(id AS INTEGER)
FROM dbo.SplitString(@FruitIds, ','))
) as childTable
WHERE mainTable.PersonId= childTable.PersonId
FOR XML PATH('')), 1, 1, '') AS Fruitname,
REPLACE(SUM(CAST(REPLACE(Price,',','.') AS DECIMAL(18,2))),'.',',') AS 'Summa price'
FROM
(
SELECT CONVERT(VARCHAR,@PersonId) as PersonId,* FROM FruitTable WHERE Id IN (SELECT CAST(id AS INTEGER)
FROM dbo.SplitString(@FruitIds, ','))
) as mainTable
GROUP BY mainTable.PersonId
But I have problem here. When I save only
in Secondtable.
It’s show all summa fruittable. It’ must show summa price = 8,5 because I have three id in secondtable.
Not show all fruit price like this summa price = 17,5.
Who is you can help me?