Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
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.
|domain login has permission in database, but gets error||3||26|
|Script to backup a Database Dayli on SQL Server Express||3||23|
|Database Mail Profiles||1||24|