摘要：declare@sqlvarchar(8000)set@sql='selectd.sBillNo,g.goodsId';SELECT@sql=@sql+','''+g.GoodName+'''=isnull(sum(caseg.GoodNamewhen'''+g.goodName+'''thend.Qtyend),0)'from(SELECTdistinctg.goodsId,g.GoodNameFROMBS_GoodsInfoginnerjoinBS_dSaleBi 阅读全文