sql server 用for xml 实现oracle中wm_concat功能
摘要:
1 SELECT [values]=stuff((SELECT ','+CASE i.invoice_type WHEN 1 THEN '通用服务发票' WHEN 2 THEN '增值税普通发票' WHEN 3 THEN '增值税专用发票' END2 FROM m_invoice i3 WHERE i.invoice_type>=14 GROUP BY i.invoice_type5 ORDER BY i.inv... 阅读全文
posted @ 2012-10-18 16:37 kristy~ 阅读(258) 评论(0) 推荐(0) 编辑