buckskrot.blogg.se

I need to determine how each row is calculated for the SalesOrderDetails table until all rows from the table are accounted for. That query will tell you 1) how many differencesīetween ListPrice and UnitPrice are there, 2) will tell you what those differences are, 3) will tell you how many rows are affected, and 4) by including Retail or Wholesale sales and by grouping it in your query, you can tell what kind of sales are impacted. To figure out if there are calculations, write a query that 1) includes a field CalculatedListPriceDiscountPercent = ((ListPrice – UnitPrice)/ListPrice),Ģ) count the rows that use CalculatedListPriceDiscountPercent by doing a count grouped by CalculatedListPriceDiscountPercent, 3) include a field to identify Retail or Wholesale sales and grouping it in your query. Hint: For Example, ProductListPrice is a source for SalesOrderDetail.UnitPrice. In the query, identify the number of rows of Wholesale and Retail sales order details to which the calculation accounts. I am using ms sql server 2005 Enterprise Evaluation Edition, and I can use the other sample dtabases, like pubs, northwind, but not adventureworksI tried diffrent ways, I am very new to this, and I try before I ask, and I had to give up, Here is what I didwhen I installed adventureworks it was like 166 mb. Another example: sometimes the SpecialOffer.DiscountPct is ignored. For example, there are multiple discounts applied to ListPrice (the In a section of an MS Word document explain all of the sources (some fields are always calculated and do not have sources) you found for the following fields.įor each of the sourced fields above, write a query like described in the “hint” above that explains how many ways that “source” is used to calculate the field. Using the AdventureWorks database determine how the following columns are calculated within the SalesOrders table: LineTotal, UnitPrice, UnitPriceDiscount, OrderQty