Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
USE [dataKLL]; GO /****** Object: StoredProcedure [dbo].[KLLsp_InventoryRoll_Variance] Script Date: 11/16/2016 12:36:20 PM ******/ SET ANSI_NULLS ON; GO SET QUOTED_IDENTIFIER ON; GO -- ============================================= -- Author: Michael Burk -- Create date: 11/16/2016 -- Description: Retrieve records for Inventory Roll Variance. -- ============================================= CREATE PROCEDURE [dbo].[KLLsp_InventoryRoll_Variance] -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here select v1.Value1 - v2.Value2 from (SELECT SUM(CalInvPc + AdjPc + RecPc + RetPc - ShipInvPc) AS Value1 FROM KLL_Cust.dbo.KLLInventoryRoll WHERE ( Date = DATEADD(d, DATEDIFF(d, 0, GETDATE()), -1) ) )as v1 CROSS JOIN ( (SELECT SUM(RepInvEndPc) as Value2 FROM KLL_Cust.dbo.KLLInventoryRoll WHERE ( Date = DATEADD(d, DATEDIFF(d, 0, GETDATE()), -1) ) ) )AS v2
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.