Jun 19

auto_pricing_data_for_italy

USE [AmazonShopForSoul]
GO
/****** Object: StoredProcedure [dbo].[auto_pricing_data_for_italy] 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].[auto_pricing_data_for_italy]
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;

/*
select p.sku, amazon_special_price_eu as price, amazon_eu_minimum_price as [minimum-seller-allowed-price], amazon_list_price_eu as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel]
from price_calculations p
inner join [italy-Inventory+Report+07-03-2018] italy on italy.sku=p.sku
*/

/*updated on July 12th, 2018*/
remove-this-phrase–no longer required
/*
select p.sku, amazon_special_price_eu as price, amazon_eu_minimum_price as [minimum-seller-allowed-price], amazon_list_price_eu as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel]
from price_calculations_jul_11_2018 p
inner join [ItalyInventoryReport07132018] italy on italy.sku=p.sku
*/

/*fix null price*/
select * from ItalyAllListingsReport07182018
where price is null

update
ItalyAllListingsReport07182018
set price=0.02
where price is null

remove-this-phrase–product that should be on amazon
select p.sku, REPLACE (round(amazon_special_price_eu,2), ‘.’, ‘,’) as price
, REPLACE (round(amazon_eu_minimum_price,2), ‘.’, ‘,’) as [minimum-seller-allowed-price]
, REPLACE (round(amazon_list_price_eu,2), ‘.’, ‘,’) as [maximum-seller-allowed-price], 1 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
from price_calculations_jul_17_2018 p
inner join ItalyAllListingsReport07182018 eu on eu.[seller-sku]=p.sku
where (eu.status=’Active’) and (p.status=1)

remove-this-phrase–remove-this-phrase–out of stock or disabled or incomplete or soon discontinued
select p.sku, REPLACE (round(amazon_special_price_eu,2), ‘.’, ‘,’) as price
, REPLACE (round(amazon_eu_minimum_price,2), ‘.’, ‘,’) as [minimum-seller-allowed-price]
, REPLACE (round(amazon_list_price_eu,2), ‘.’, ‘,’) as [maximum-seller-allowed-price]
, 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
from price_calculations_jul_17_2018 p
inner join ItalyAllListingsReport07182018 eu on eu.[seller-sku]=p.sku
where (p.status=2)

remove-this-phrase–not in our current supplier inventory
remove-this-phrase–but on our Amazon inventory
select eu.[seller-sku] as sku, 0 as quantity
, replace(eu.price,’.’,’,’) as price, eu.asin1 as asinremove-this-phrase–, eu.[item-name]
from ItalyAllListingsReport07182018 eu remove-this-phrase–price_calculations_jul_17_2018 p
where eu.[seller-sku] not in (select sku from price_calculations_jul_17_2018)

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

Jun 19

auto_pricing_data_for_germany

USE [AmazonShopForSoul]
GO
/****** Object: StoredProcedure [dbo].[auto_pricing_data_for_germany] 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].[auto_pricing_data_for_germany]
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;

/*
select p.sku, round(amazon_special_price_eu,2) as price, round(amazon_eu_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price_eu,2) as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel], germany.asin
from price_calculations p
inner join [germany-Inventory+Report+07-03-2018] germany on germany.sku=p.sku
*/

remove-this-phrase–no more required
/*
select p.sku, round(amazon_special_price_eu,2) as price, round(amazon_eu_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price_eu,2) as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel], germany.asin
from price_calculations_jul_11_2018 p
inner join [GermanyInventoryReport07132018] germany on germany.sku=p.sku
*/

/*fix null price*/
select * from GermanyAllListingsReport07182018
where price is null

update
GermanyAllListingsReport07182018
set price=0.01
where price is null

remove-this-phrase–product that should be on amazon
select p.sku, REPLACE (round(amazon_special_price_eu,2), ‘.’, ‘,’) as price
, REPLACE (round(amazon_eu_minimum_price,2), ‘.’, ‘,’) as [minimum-seller-allowed-price]
, REPLACE (round(amazon_list_price_eu,2), ‘.’, ‘,’) as [maximum-seller-allowed-price], 1 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
from price_calculations_jul_17_2018 p
inner join GermanyAllListingsReport07182018 germany on germany.[seller-sku]=p.sku
where (germany.status=’Active’) and (p.status=1)

remove-this-phrase–remove-this-phrase–out of stock or disabled or incomplete or soon discontinued
select p.sku, REPLACE (round(amazon_special_price_eu,2), ‘.’, ‘,’) as price
, REPLACE (round(amazon_eu_minimum_price,2), ‘.’, ‘,’) as [minimum-seller-allowed-price]
, REPLACE (round(amazon_list_price_eu,2), ‘.’, ‘,’) as [maximum-seller-allowed-price]
, 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
from price_calculations_jul_17_2018 p
inner join GermanyAllListingsReport07182018 germany on germany.[seller-sku]=p.sku
where (p.status=2)

remove-this-phrase–not in our current supplier inventory
remove-this-phrase–but on our Amazon inventory
select germany.[seller-sku] as sku, 0 as quantity
, replace(germany.price,’.’,’,’) as price, germany.asin1 as asinremove-this-phrase–, germany.[item-name]
from GermanyAllListingsReport07182018 germany remove-this-phrase–price_calculations_jul_17_2018 p
where germany.[seller-sku] not in (select sku from price_calculations_jul_17_2018)

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

Jun 19

auto_pricing_data_for_france

USE [AmazonShopForSoul]
GO
/****** Object: StoredProcedure [dbo].[auto_pricing_data_for_france] 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].[auto_pricing_data_for_france]
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;

/*
select p.sku, amazon_special_price_eu as price, amazon_eu_minimum_price as [minimum-seller-allowed-price]
, amazon_list_price_eu as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel]
from price_calculations p
inner join [france-Inventory+Report+07-03-2018] france on france.sku=p.sku
*/

select p.sku, amazon_special_price_eu as price, amazon_eu_minimum_price as [minimum-seller-allowed-price]
, amazon_list_price_eu as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time], ‘default’ as [fulfillment-channel]
from price_calculations_jul_11_2018 p
inner join [FranceInventoryReport07132018] france on france.sku=p.sku

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

Jun 19

auto_pricing_data_for_canada

USE [AmazonShopForSoul]
GO
/****** Object: StoredProcedure [dbo].[auto_pricing_data_for_canada] 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].[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 NOCOUNT ON;

update [intermediate-output_price_calculations]
set sku=concat(‘shopforsoul-‘, sku)
where sku not like ‘%shopfor%’;

select * from CanadaAllListingsReport07182018;

remove-this-phrase–minimum price update
select p.sku, round(amazon_special_price,2) as price, round(amazon_ca_abs_minimum,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price], 1 as quantity, 3 as [handling-time]
, ‘default’ as [fulfillment-channel]
from [price_calculations_jul_17_2018] p
inner join CanadaAllListingsReport07182018 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status=1)

remove-this-phrase–deactivate on amazon as they are disabled on ShopForSoul.com
select p.sku, round(amazon_special_price,2) as price, round(amazon_ca_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price], 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel], canada.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
from [intermediate-output_price_calculations] p
inner join CanadaAllListingsReport07182018 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status=2)

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

Jun 19

android_product_name_mismatch

USE [AmazonInventory-2018-06-14]
GO
/****** Object: StoredProcedure [dbo].[android_product_name_mismatch] Script Date: 2020-06-19 10:18:12 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].[android_product_name_mismatch]
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;

SELECT ama.asin1, ama.[seller-sku], supplier.sku, ama.[item-name] as name_on_amazon, supplier.name as name_at_supplier_side
FROM [ActiveListingsReport-06-19-2018] ama
inner join [all-to-upload-without-description] supplier on trim(ama.[seller-sku])=concat(‘shopforsoul-‘,supplier.sku)
where ama.[item-name] <> supplier.name and ( (ama.[item-name] like ‘%android%’) or (supplier.name like ‘%android%’) )
order by ama.[item-name]

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

Jun 19

adjust_stock_status_data_for_canada

/****** Object: StoredProcedure [dbo].[adjust_stock_status_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].[adjust_stock_status_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 NOCOUNT ON;

update price_calculations_dec_23_2018
set sku=concat(‘shopforsoul-‘, sku)
where sku not like ‘%shopfor%’;

remove-this-phrase–select * from CanadaAllListingsReport12252018;

remove-this-phrase–minimum price update
select p.sku, round(amazon_special_price,2) as price, round(amazon_ca_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price], 1 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
from [price_calculations_dec_23_2018] p
inner join CanadaAllListingsReport12282018 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status=1)

remove-this-phrase–deactivate on amazon as they are disabled on ShopForSoul.com
select p.sku, round(amazon_special_price,2) as price, round(amazon_ca_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price], 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel], canada.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
from [price_calculations_dec_23_2018] p
inner join CanadaAllListingsReport12282018 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status <> 1)

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

Jun 19

remove this word product_name_mismatch

USE ProductAndPriceManagement
GO
/****** Object: StoredProcedure [dbo].[product_name_mismatch] Script Date: 2020-06-19 9:56:07 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].[product_name_mismatch]
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;

/****** Script for SelectTopNRows command from SSMS ******/
SELECT ama.asin1, ama.[seller-sku], supplier.sku, ama.[item-name] as name_on_amazon, supplier.name as name_at_supplier_side
FROM [ActiveListingsReport-06-19-2018] ama
inner join [all-to-upload-without-description] supplier on trim(ama.[seller-sku])=concat(‘shopforsoul-‘,supplier.sku)
where ama.[item-name] <> supplier.name
order by ama.[item-name]

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

Jun 19

update_inactive_listings_uk

USE [AdjustInActiveInventory]
GO

/****** Object: StoredProcedure [dbo].[update_inactive_listings_uk] Script Date: 2020-06-19 9:55:55 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Jun 13

OOP in Matlab

Introduction to Object-Oriented Programming in MATLABhttps://ww2.mathworks.cn/matlabcentral/fileexchange/18971-comparison-of-c-and-matlab-using-oop-example?s_tid=FX_rc1_behav

Matlab OOP
https://www.slideshare.net/HosseinMolhem/matlab-oop?qid=9408235e-e0c5-4b8c-8003-99d8eb096776&v=&b=&from_search=1

Book: OOP in Matlab
https://www.slideshare.net/AlbanLevy/object-oriented-programming-in-matlab?qid=9408235e-e0c5-4b8c-8003-99d8eb096776&v=&b=&from_search=2

*** . *** *** . *** . *** . ***

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

Jun 13

OOP in Matlab

Examples and How To

*** . *** *** . *** . *** . ***

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