USE [AmazonProfitLossOrderManagement]
\nGO
\n\/****** Object: StoredProcedure [dbo].[our_profit_loss] Script Date: 2020-06-19 10:17:11 PM ******\/
\nSET ANSI_NULLS ON
\nGO
\nSET QUOTED_IDENTIFIER ON
\nGO
\nremove-this-phrase– Alter Procedure our_profit_loss
\nremove-this-phrase– =============================================
\nremove-this-phrase– Author: <Author,,Name>
\nremove-this-phrase– Create date: <Create Date,,>
\nremove-this-phrase– Description:\t<Description,,>
\nremove-this-phrase– =============================================
\nCREATE PROCEDURE [dbo].[our_profit_loss]
\nAS
\nBEGIN
\nremove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
\nremove-this-phrase– interfering with SELECT statements.
\nSET NOCOUNT ON;<\/p>\n
\/****** Script for SelectTopNRows command from SSMS ******\/
\ndeclare @customer_paid float;
\ndeclare @ur_total_cost float;<\/p>\n
SELECT @customer_paid=([item-price-cad] + [item-tax-cad] + [shipping-price-cad] + [shipping-tax-cad] ), @ur_total_cost = ([our_purchase_price] + [our_shipping_price] + our_shipping_insurance)
\nFROM [AmazonProfitLossOrderManagement].[dbo].[order_and_profit_loss_mgmt_july_15th_2018]<\/p>\n
select @customer_paid, @ur_total_cost<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset total_customer_pay=([item-price-cad] + [item-tax-cad] + [shipping-price-cad] + [shipping-tax-cad] )<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset our_total_cost=([our_purchase_price] + [our_shipping_price] + our_shipping_insurance)<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset our_profit_loss=round(total_customer_pay-our_total_cost-amazon_fees_cad,2)<\/p>\n
select * from [order_and_profit_loss_mgmt_july_15th_2018]<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset our_purchase_price=0 where our_purchase_price is null<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset our_shipping_price=0 where our_shipping_price is null<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset our_shipping_insurance=0 where our_shipping_insurance is null<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset refund_to_customer=0 where refund_to_customer is null<\/p>\n
select * from [order_and_profit_loss_mgmt_july_15th_2018]
\norder by [purchase-date] desc<\/p>\n
update [order_and_profit_loss_mgmt_july_15th_2018]
\nset order_cancelled=0
\nwhere order_cancelled is null<\/p>\n
select sum(our_profit_loss) as proft, sum(our_profit_loss)*0.15 as possible_tax, sum(our_profit_loss)*0.15 as possible_vat,
\n(sum(our_profit_loss) – sum(our_profit_loss)*0.15) as actual_profit
\nfrom [order_and_profit_loss_mgmt_july_15th_2018]
\nwhere order_cancelled=0<\/p>\n
END
\nGO
\n*** . *** *** . *** . *** . ***<\/p>\n
Training Courses: <\/strong>http:\/\/Training.SitesTree.com<\/a> <\/em> <\/em> Facebook Groups\/Forums to discuss (Q & A): <\/strong><\/em> https:\/\/www.facebook.com\/banglasalearningschool<\/a> 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. <\/em>http:\/\/sitestree.com\/training\/<\/a><\/p>\n Join, Discuss, and Thrive:<\/strong> Bangladesh and Canada: https:\/\/www.facebook.com\/groups\/398414183875009<\/a><\/p>\n Bangladesh: IT & Eng: Canada: https:\/\/www.facebook.com\/groups\/480297675634630<\/a><\/p>\n BUETians in Ontario: https:\/\/www.facebook.com\/groups\/371982239854027<\/a><\/p>\n Worldwide IT: https:\/\/www.facebook.com\/groups\/28362061867<\/a><\/p>\n
\nBlog<\/strong>: http:\/\/Bangla.SaLearningSchool.com<\/a>, http:\/\/SitesTree.com<\/a><\/em>
\n8112223 Canada Inc\/Justetc<\/strong>: http:\/\/JustEtc.net<\/a><\/em>
\nYoutube: <\/em>https:\/\/www.youtube.com\/channel\/UCHrtq0pV8mEuTLGd2-Lp9ig\/playlists<\/a>
\nMedium: <\/strong><\/em>https:\/\/medium.com\/@SayedAhmedCanada<\/a><\/p>\n
\nSayed Ahmed<\/strong>
\n<\/em>
\nBSc. Eng. in Comp. Sc. & Eng. (BUET)<\/strong><\/em>
\nMSc. in Comp. Sc. (U of Manitoba, Canada)<\/strong><\/em>
\nMSc. in Data Science and Analytics (Ryerson University, Canada)<\/strong><\/em>
\nLinkedin<\/strong>: https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a>
\n<\/em><\/p>\n
\nhttps:\/\/www.facebook.com\/salearningschool<\/a><\/p>\n
\nhttps:\/\/www.facebook.com\/justetcsocial<\/a><\/p>\n
\nFinance: https:\/\/www.facebook.com\/groups\/1792339521056034<\/a><\/p>\n