Go4Expert - View Single Post

appstester

Hi,

I am a newbie on MS SQL 2008 and wanted your help with SQL query on Adventureworks database.

--
Part a. For every Product, show me it’s lowest price in History, Highest Price in History, the difference between the 2 prices, Count of SalesDetails, Sum of LineTotal.

Part b. Create a SP that passes a minimum SalesDetails Count. Results will be filtered by Products that only have a SalesDetail Count greater than the number given by the user at runtime.

--

Was wondering if you can give some idea on how to tackle this question, i am completely confused as to where to start this from (which table to choose).

Appreciate your time and help.

Regards,
MJ

appstester Newbie Member
3Oct2012,18:22
	Hi, I am a newbie on MS SQL 2008 and wanted your help with SQL query on Adventureworks database. -- Part a. For every Product, show me it’s lowest price in History, Highest Price in History, the difference between the 2 prices, Count of SalesDetails, Sum of LineTotal. Part b. Create a SP that passes a minimum SalesDetails Count. Results will be filtered by Products that only have a SalesDetail Count greater than the number given by the user at runtime. -- Was wondering if you can give some idea on how to tackle this question, i am completely confused as to where to start this from (which table to choose). Appreciate your time and help. Regards, MJ