Skin/Money Twins True Segoe UI;9.75 System 0 0 0 True True True False False False False False False False False False False False 0 0 0 True True True True True True True False True True True True True True True True True False False 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AIzaSyCUdbx6Ho01MnDxl0tBwnUmx_98__Y0Whk /maps/api/place/textsearch/json?query={0}&key={1} + https://maps.googleapis.com 10000 10000 True True True True True True True True True True True True True True True True True 30 30 TRACE True 8.8.8.8 True False False False 4 2 DECLARE @newId bigint DECLARE @name varchar(50) = '{0}' DECLARE @group bigint = {1} SELECT @newId = NextId FROM InvGroupSequenceNum WHERE Name = @name AND InvGroupId = @group; IF @newId IS NULL BEGIN --Create record for Name and Group INSERT INTO InvGroupSequenceNum (InvGroupId, Name, NextId) VALUES (@group, @name, 1000) SELECT @newId = NextId FROM InvGroupSequenceNum WHERE Name = @name AND InvGroupId = @group; END DECLARE @nextId bigint SELECT @nextId = @newId + 1; UPDATE InvGroupSequenceNum SET NextId = @nextId WHERE Name = @name AND InvGroupId = @group; SELECT @newId; DECLARE @newId bigint DECLARE @companycode bigint = {0} SELECT @newId = NextSKU FROM NextSKUSequence WHERE CompanyCode = @companycode; IF @newId IS NULL BEGIN --Create record for Name and Group INSERT INTO NextSKUSequence (CompanyCode, NextSKU) VALUES (@companycode, 1000) SELECT @newId = NextSKU FROM NextSKUSequence WHERE CompanyCode = @companycode; END DECLARE @nextId bigint SELECT @nextId = @newId + 1; UPDATE NextSKUSequence SET NextSKU = @nextId WHERE CompanyCode = @companycode; SELECT @newId; DECLARE @newId bigint DECLARE @name varchar(50) = '{0}' DECLARE @group bigint = {1} SELECT @newId = NextId FROM CompanySequenceNum WHERE Name = @name AND CompanyCode = @group; IF @newId IS NULL BEGIN --Create record for Name and Group INSERT INTO CompanySequenceNum (CompanyCode, Name, NextId) VALUES (@group, @name, 1000) SELECT @newId = NextId FROM CompanySequenceNum WHERE Name = @name AND CompanyCode = @group; END DECLARE @nextId bigint SELECT @nextId = @newId + 1; UPDATE CompanySequenceNum SET NextId = @nextId WHERE Name = @name AND CompanyCode = @group; SELECT @newId; SELECT Barcode FROM productBarcodes WHERE TRY_CAST(Barcode AS INT) IS NOT NULL and LEN(barcode) <7 order by TRY_CAST(barcode as INT) DECLARE @RC int DECLARE @pGroup bigint DECLARE @pName varchar(50) DECLARE @pOutput bigint DECLARE @result bigint -- TODO: Set parameter values here. Set @pGroup={0} Set @pName='{1}' EXECUTE @RC = [dbo].[procGetInvGroupSeqNum] @pGroup ,@pName ,@pOutput = @result OUTPUT True True True True True True True True Basic HeadOffice2_5 0 False C:\ProgramData\RealTimePOS\HeadOffice2_5\Logs 0 0 120 pk_10632150_UOJB6RQ6HCCDMZPOFI3WVR50AS2TC5PG 42231215 Bar Default True https://rtwebapi.azurewebsites.net True True 2 True False 300 True False