Bresleveloper Digital - the best at SharePoint, PowerApps and Office365, Contact us now!

mvc - http://www.orchardproject.net/  by gnadysh  

SELECT        SUBSTRING((SELECT ', ' + CAST([קוד זיהוי] AS VARCHAR(20))  FROM [dbo].[All] AllSub      WHERE AllSub.משפחה = AllMain.משפחה      For XML Path('')), 2, 8000) AS [קוד זיהוי]      FROM [dbo].[All] AllMain GROUP BY משפחה, [שם] ,[רחוב] ,[מספר בית], [עיר]; point is that whatever field that is not in the GROUP BY the SQL Server wants you to group it somehow, and you need to to this XML trick for each one.  

http://jsbin.com/ijawag/4/edit Genadysh: http://blogs.microsoft.co.il/blogs/genadysh/