PivotTable
摘要:
SELECT InvoiceNo,isnull([1],'')+','+isnull([2],'')+','+isnull([3],'')+','+isnull([4],'') ActionType FROM ( SELECT InvoiceNo,cast(SendType as varchar) ActionType from dbo.PrintShareEmail SI with (nolock) where 1=1 --AND UserID=@userid AND (@type 阅读全文
posted @ 2013-06-08 10:01 远大前程 阅读(131) 评论(0) 推荐(0) 编辑