Red Rook

begin tran IF NOT EXISTS (SELECT 1 FROM IM_LOC_GRP where LOC_GRP_ID = 'IPAAS') BEGIN INSERT INTO [dbo].[IM_LOC_GRP]([LOC_GRP_ID],[DESCR],[DESCR_UPR]...

IF OBJECT_ID('USR_MAG_ITEM_EXP_RUN_PRC_AFTER', 'P') IS NULL EXEC ('CREATE PROCEDURE [USR_MAG_ITEM_EXP_RUN_PRC_AFTER] as BEGIN SELECT 1 E...

-- CHANGE ALL PARTS IN BOLD USE [msdb] GO /*Delete existing Job [ipaas - update location specific inventory]*/ --EXEC msdb.dbo.sp_delete_job @job_id=N'...

--You must change which price field is used. The code below uses PRC_2 IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'IM_I...

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'IM_ITEM' AND COLUMN_NAME = 'USR_HTML_DESCR') BEGIN ALTER TABLE I...

IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[USR_COPY_BARCOD_JSON]') AND type in (N'TR')) EXEC ('CREAT...

select im_item.item_no, '['+ REPLACE( REPLACE( REPLACE( REPLACE( (select barcod_id, barcod from im_barcod where item_no = im_item.item_no and barcod...

update USR_CPHIVE_SUBSCRIPTION set SUBSCRIBED = 'Y' where scope like 'product%' and scope not like '%deleted'