Jun 19

sync_with_uk_inventory

/****** Object: StoredProcedure [dbo].[sync_with_uk_inventory] Script Date: 2020-06-19 10:12:46 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].[sync_with_uk_inventory]
AS
BEGIN
remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
remove-this-phrase– interfering with SELECT statements.
SET NOCOUNT ON;

delete from [uk-ActiveListingsReport-06-17-2018] where [uk-ActiveListingsReport-06-17-2018].quantity=0

remove-this-phrase–Germany active not in uk
remove-this-phrase–deactivate them
select trim(ge.seller_sku)
from [germany-ActiveListingsReport-06-17-2018] ge
where (
trim(ge.seller_sku) not in (select trim(uk.seller_sku)
from [uk-ActiveListingsReport-06-17-2018] uk )
)
remove-this-phrase–

select trim(ge.seller_sku) as sku, ge.asin1 as asin, ge.quantity, ge.price
into #GermanyActiveProducts
from [germany-ActiveListingsReport-06-17-2018] ge

select trim(uk.seller_sku) as sku, uk.asin1 as asin, uk.quantity, uk.price
into #UKActiveProducts
from [uk-ActiveListingsReport-06-17-2018] uk

select * from #UKActiveProducts

select * from
#GermanyActiveProducts ge
where ge.sku not in (select sku from #UKActiveProducts)

select uk.* from
#UKActiveProducts uk
where uk.sku not in (select sku from #GermanyActiveProducts)

END
GO
*** . *** *** . *** . *** . ***

Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada


Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool

https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/

Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034

Bangladesh and Canada: https://www.facebook.com/groups/398414183875009

Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630

BUETians in Ontario: https://www.facebook.com/groups/371982239854027

Worldwide IT: https://www.facebook.com/groups/28362061867

JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261