Posts

Showing posts from December, 2012

cms מומלץ

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

SQL Group By And Group_Concat Exapmle

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.

Image Rotator by Genadysh example

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