Dataset: SalesOrderDetail

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Data source name   AdventureWorks 
 Referenced data set    
 Command type   Query 

Collapse image Parameters


Name 
@SalesOrderNumber
Total: 1 parameter(s)

Collapse image Fields


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      
Total: 9 field(s)

Collapse image Filters


No filters exist

Collapse image Query


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

Collapse image See also


About this documentation