请问谁有关于OVAR的查询代码

yanwei82123300

请问谁有关于OVAR的查询代码，我想通过ACCESS来个相关的查询，然后导出到EXCEL,谢谢
我公司的OVAR是word格式！！

cw1632000

这是根据OVAR运行参数情况查询代码
select UserName,a.* from dbo.FS_ClosedOrderAnalysisRun a inner join FS_UserAccess b on a.UserID=b.UserID ORDER BY StartDateTime desc

这是查询详细OVAR差异数据代码，我写了个存储过程：
ALTER Proc [dbo].[OVAR_Variance_Analysis]
(@BeginDate as datetime,
@EndDate as datetime,
@bit as int)

as

IF @bit=1
        BEGIN
Select b.ItemNumber,b.ItemDescription,a.OrderType,a.OrderNumber+'/'+CONVERT(char(3),a.OrderLineNumber) as 'Order',a.VendorCustomerWorkCenter,a.BuyerPlannerCSR,a.OrderStatus,a.LineClosedDate,a.OrderLineType,
                a.OrderLineStatus,a.ItemOrderedQuantity,a.ReceiptQuantity,
                a.StandardCost,--标准成本--
                a.ActualCost,  --入库成本--
                a.IssueVarianceAmount,--发出差异5001008--
                a.YieldVarianceAmount,--产出差异5001008--
                a.ScrapVarianceAmount,--残料差异5001012--
                a.MaterialSubstitutionVarianceAmount,--替换差异5001012--
                a.LaborVarianceAmount,--人工差异5001010--
                a.OverheadVarianceAmount,--间接费用差异5001011--
                a.MethodVarianceAmount,--方法差异5001012--
                a.ByproductVarianceAmount,--副产品差异5001012--
                a.StandardCostVarianceAmount,--标准成本差异5001006--
                a.RollUpVarianceAmount,--成本滚加差异5001012--
                a.CustomProductVarianceAmount,--定制产品差异5001012--
                a.ByproductAccumulatorVarianceAmount,--副产品累计差异5001012--
                a.ActualCostSubstituteAmount,--入库累计成本--
                --a.AccumulatedMaterialCost,--累计材料成本--
                --a.AccumulatedLaborCost,--累计人工成本--
                --a.AccumulatedFixedOverheadCost,--累计固定间接费用--
                a.ClosedOrderAnalysisRunKey,--关闭的KEY--
                --,right(c.MST_ACT_NO,7) as AccountNumber,
                --c.BATCH_NO,
                --c.GLAccountGroupDescription
                dateadd(day,datediff(day,0,c.StartDateTime),0) as 'DATE'
                from dbo.FS_ClosedOrderLineVariance a
                inner join FS_Item b on a.ItemKey=b.ItemKey
                INNER JOIN  dbo.FS_ClosedOrderAnalysisRun c ON a.ClosedOrderAnalysisRunKey=c.ClosedOrderAnalysisRunKey
--                inner join (Select h.GLAccountGroupDescription,i.* From dbo.GL_BATCHDETAILACCT i inner join (SELECT GLAccountGroup,GLAccountGroupDescription  FROM FS_GLAccountGroup WHERE GLAccountType<>'') h
--                on right(i.MST_ACT_NO,7)=h.GLAccountGroup
--                where BATCH_SRCE='OVAR' AND RIGHT(i.MST_ACT_NO,7) IN (5001006,5001007,5001008,5001009,5001010,5001011,5001012)) c
--                on a.OrderNumber=REF_NO2 and a.OrderLineNumber=CONVERT(int, c.REF_NO3)
                ORDER BY a.ClosedOrderAnalysisRunKey,a.OrderType,a.OrderNumber+'/'+CONVERT(char(3),a.OrderLineNumber) DESC
        END
ELSE
        BEGIN
Select b.ItemNumber,b.ItemDescription,a.OrderType,a.OrderNumber+'/'+CONVERT(char(3),a.OrderLineNumber) as 'Order',a.VendorCustomerWorkCenter,a.BuyerPlannerCSR,a.OrderStatus,a.LineClosedDate,a.OrderLineType,
                a.OrderLineStatus,a.ItemOrderedQuantity,a.ReceiptQuantity,
                a.StandardCost,--标准成本--
                a.ActualCost,  --入库成本--
                a.IssueVarianceAmount,--发出差异5001008--
                a.YieldVarianceAmount,--产出差异5001008--
                a.ScrapVarianceAmount,--残料差异5001012--
                a.MaterialSubstitutionVarianceAmount,--替换差异5001012--
                a.LaborVarianceAmount,--人工差异5001010--
                a.OverheadVarianceAmount,--间接费用差异5001011--
                a.MethodVarianceAmount,--方法差异5001012--
                a.ByproductVarianceAmount,--副产品差异5001012--
                a.StandardCostVarianceAmount,--标准成本差异5001006--
                a.RollUpVarianceAmount,--成本滚加差异5001012--
                a.CustomProductVarianceAmount,--定制产品差异5001012--
                a.ByproductAccumulatorVarianceAmount,--副产品累计差异5001012--
                a.ActualCostSubstituteAmount,--入库累计成本--
                --a.AccumulatedMaterialCost,--累计材料成本--
                --a.AccumulatedLaborCost,--累计人工成本--
                --a.AccumulatedFixedOverheadCost,--累计固定间接费用--
                a.ClosedOrderAnalysisRunKey,--关闭的KEY--
                --,right(c.MST_ACT_NO,7) as AccountNumber,
                --c.BATCH_NO,
                --c.GLAccountGroupDescription
                dateadd(day,datediff(day,0,c.StartDateTime),0) as 'DATE'
                from dbo.FS_ClosedOrderLineVariance a
                inner join FS_Item b on a.ItemKey=b.ItemKey
                INNER JOIN  dbo.FS_ClosedOrderAnalysisRun c ON a.ClosedOrderAnalysisRunKey=c.ClosedOrderAnalysisRunKey
--                inner join (Select h.GLAccountGroupDescription,i.* From dbo.GL_BATCHDETAILACCT i inner join (SELECT GLAccountGroup,GLAccountGroupDescription  FROM FS_GLAccountGroup WHERE GLAccountType<>'') h
--                on right(i.MST_ACT_NO,7)=h.GLAccountGroup
--                where BATCH_SRCE='OVAR' AND RIGHT(i.MST_ACT_NO,7) IN (5001006,5001007,5001008,5001009,5001010,5001011,5001012)) c
--                on a.OrderNumber=REF_NO2 and a.OrderLineNumber=CONVERT(int, c.REF_NO3)
                where dateadd(day,datediff(day,0,c.StartDateTime),0) between @BeginDate and @EndDate
                ORDER BY a.ClosedOrderAnalysisRunKey,b.ItemNumber,a.OrderType,a.OrderNumber+'/'+CONVERT(char(3),a.OrderLineNumber) DESC               
        END

yanwei82123300

cw1632000 请问能否使用ACCESS做个代码1

cw1632000

你把下面下句截下来，将参数格式改一下，就是Access语句呀，只是ACCESS不支持存储过程

yanwei82123300

cw1632000老师谢谢帮助，我将您写的数据给IT部门看看他们是否可以帮助，谢谢