Dataset: SalesOrderDetail
Property | Value |
Data source name | AdventureWorks |
Referenced data set | |
Command type | Query |
Name |
@SalesOrderNumber |
Name | Source column | Data type | Caption | Value | Is calculated field |
SalesOrderDetailID | SalesOrderDetailID | System.Int32 | |||
OrderQty | OrderQty | System.Int16 | |||
UnitPrice | UnitPrice | System.Decimal | |||
UnitPriceDiscount | UnitPriceDiscount | System.Decimal | |||
LineTotal | LineTotal | System.Decimal | |||
CarrierTrackingNumber | CarrierTrackingNumber | System.String | |||
SalesOrderID | SalesOrderID | System.Int32 | |||
Name | Name | System.String | |||
ProductNumber | ProductNumber | System.String |
SELECT SOD.SalesOrderDetailID, SOD.OrderQty, SOD.UnitPrice, CASE WHEN SOD.UnitPriceDiscount IS NULL THEN 0 ELSE SOD.UnitPriceDiscount END AS UnitPriceDiscount, SOD.LineTotal, SOD.CarrierTrackingNumber, SOD.SalesOrderID, P.Name, P.ProductNumber FROM Sales.SalesOrderDetail SOD INNER JOIN Production.Product P ON SOD.ProductID = P.ProductID INNER JOIN Sales.SalesOrderHeader SOH ON SOD.SalesOrderID = SOH.SalesOrderID WHERE (SOH.SalesOrderNumber = @SalesOrderNumber) ORDER BY SOD.SalesOrderDetailID |