শনিবার, ৫ এপ্রিল, ২০১৪

Multi row in single column in Sql

query
SELECT  distinct   CONVERT(varchar,EntryDate,103)EntryDate,
    mt.VoucherNo,sum(mt.DAmount)Amt,mt.AccStatement,
    STUFF((SELECT ', ' +(select AccChart.ActName from AccChart where CONVERT(nvarchar(50),AccChart.ActCode)= t2.ActCode) FROM AccGl2014 t2
   WHERE t2.VoucherNo = mt.VoucherNo FOR XML PATH (''))  ,1,2,'')  as AccountName  ,STUFF((SELECT ', ' + t3.Descrp  FROM AccGl2014 t3
     WHERE t3.VoucherNo = mt.VoucherNo FOR XML PATH (''))  ,1,2,'')  as Descrp              
    FROM     dbo.AccGl2014 mt where (mt.AccStatement='JV' or mt.AccStatement='Cash' or mt.AccStatement='Bank' ) and mt.EntryDate
    between '04/01/2014' and '04/05/2014'   group by mt.VoucherNo,mt.EntryDate,mt.AccStatement order by mt.VoucherNo desc


normal code

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন