/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_usa] Script Date: 2020-06-19 10:15:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[xls_auto_pricing_data_for_usa] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with SELECT statements. SET …
Category: ব্লগ । Blog
ব্লগ । Blog
Jun 19
xls_auto_pricing_data_for_Uk_eu
/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_Uk_eu] Script Date: 2020-06-19 10:15:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[xls_auto_pricing_data_for_Uk_eu] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with SELECT statements. SET …
Jun 19
xls_auto_pricing_data_for_canada
/****** Object: StoredProcedure [dbo].[xls_auto_pricing_data_for_canada] Script Date: 2020-06-19 10:15:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[xls_auto_pricing_data_for_canada] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with SELECT statements. SET …
Jun 19
why_status_inactive
/****** Object: StoredProcedure [dbo].[why_status_inactive] Script Date: 2020-06-19 10:15:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[why_status_inactive] AS BEGIN select p.[Stock Status], s.[Stock Status] ,trim(concat(‘shopforsoul-‘,s.[Model Code])) ,trim(p.sku) , p.* from [price_calculations_feb-01-2019] p remove-this-phrase–inner join CanadaAllListingsReport02042019 canada …
Jun 19
update_supplier_sku
/****** Object: StoredProcedure [dbo].[update_supplier_sku] Script Date: 2020-06-19 10:15:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_supplier_sku] AS BEGIN update [DealWithAmazonShopForSoul].[dbo].[supplier-dec-28-2018] set Model_Code=concat(‘shopforsoul-‘, Model_Code) where Model_Code not like ‘%shopfor%’; END GO *** . *** *** . …
Jun 19
update_sku_once_for_price_calculations
USE [AmazonShopForSoul] GO /****** Object: StoredProcedure [dbo].[update_sku_once_for_price_calculations] Script Date: 2020-06-19 10:16:30 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_sku_once_for_price_calculations] AS BEGIN select * from price_calculations where sku not like ‘%shopfor%’; update price_calculations set sku=concat(‘shopforsoul-‘, sku) …
Jun 19
update_sku_once
USE [AmazonShopForSoul] GO /****** Object: StoredProcedure [dbo].[update_sku_once] Script Date: 2020-06-19 10:16:30 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_sku_once] AS BEGIN select * from all_to_upload_without_description where sku not like ‘%shopfor%’; update price_calculations_jul_17_2018 set sku=concat(‘shopforsoul-‘, sku) …
Jun 19
update_inactive_listings_uk
USE [AdjustInActiveInventory] GO /****** Object: StoredProcedure [dbo].[update_inactive_listings_uk] Script Date: 2020-06-19 10:18:38 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_inactive_listings_uk] AS BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Jun 19
update_inactive_listings_eu
USE [AdjustInActiveInventory] GO /****** Object: StoredProcedure [dbo].[update_inactive_listings_eu] Script Date: 2020-06-19 10:18:38 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_inactive_listings_eu] as BEGIN remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from remove-this-phrase– interfering with …
Jun 19
update_exchange_rate_and_price
USE [AmazonProfitLossOrderManagement] GO /****** Object: StoredProcedure [dbo].[update_exchange_rate_and_price] Script Date: 2020-06-19 10:17:11 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO remove-this-phrase– Alter Procedure update_exchange_rate_and_price remove-this-phrase– ============================================= remove-this-phrase– Author: <Author,,Name> remove-this-phrase– Create date: <Create Date,,> remove-this-phrase– Description: <Description,,> remove-this-phrase– ============================================= CREATE PROCEDURE [dbo].[update_exchange_rate_and_price] @exchange_rate_from_eu float, @exchange_rate_from_gbp float AS BEGIN remove-this-phrase– SET NOCOUNT ON added to …
