从Mssql导出数据到excel表中

最新推荐文章于 2024-07-25 10:59:11 发布

ojuju10

最新推荐文章于 2024-07-25 10:59:11 发布

阅读量1.5k

点赞数

本文链接：https://blog.csdn.net/ojuju10/article/details/1611431

版权

insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:/Reporttemplate/PPVAPO.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
([Item No],[Item Description],[Item English Description],[StockingType],[Supplier ID],[Supplier Name],[IDCO],[IDCO Group],[IDCO Sub Group],[Receive Qty],[UOM],[Reason Code],[Average Price Last year],[Average Price This Year],[Variance],[Var Amount],[Remark])
SELECT ItemNo,ItemDescription,ItemEnglishDescription,StockingType,SupplierID,SupplierName,IDCO1,IDCO2,IDCO,ReceiveQty,UOM,case when Variance<>0 then ReasonCode else '' end,AveragePriceLastyear,AveragePrice,Variance,VarAmount,'' as Remark
FROM PPTREPORTAPO WHERE PPTDATE=@CurDate AND WarehouseIDJDE=@WarehouseIDJDE and ReportType=@ReportType1
order by ItemNo