SELECT MSG=COALESCE(MAX(CASE WHEN GENT = 1 THEN Message END), '') + COALESCE(MAX(CASE WHEN GENT = 2 THEN Message END), '') + COALESCE(MAX(CASE WHEN GENT = 3 THEN Message END), '') ,SDATE FROM ( SELECT TOP 10 GENT=RANK() OVER(PARTITION BY DATE ORDER BY DATE DESC),* FROM My_Table WITH (NOLOCK) ORDER BY DATE DESC)O GROUP BY DATE ORDER BY DATE DESC
Select distinct Date, ( SELECT SUBSTRING( ( SELECT '+' + T2.Message FROM EMptest T2 where T2.Date=T1.Date FOR XML PATH('')),2,200000) AS Message ) as Message from EMptest as T1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)