Dataset: ProductCatalog

CollapseAll image

Collapse image Dataset properties


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

Collapse image Parameters


Name 
@Language
Total: 1 parameter(s)

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
ProdSubCat ProdSubCat System.String      
ProdModel ProdModel System.String      
ProdCat ProdCat System.String      
Description Description System.String      
LargePhoto LargePhoto System.Byte[]      
ProdName ProdName System.String      
ProductNumber ProductNumber System.String      
Color Color System.String      
Size Size System.String      
Weight Weight System.Decimal      
StandardCost StandardCost System.Decimal      
Style Style System.String      
Class Class System.String      
ListPrice ListPrice System.Decimal      
Total: 14 field(s)

Collapse image Filters


No filters exist

Collapse image Query


SELECT      PS.Name AS ProdSubCat, PM.Name AS ProdModel, PC.Name AS ProdCat, PD.Description, PP.LargePhoto, P.Name AS ProdName, P.ProductNumber, 
            P.Color, P.Size, P.Weight, P.StandardCost, P.Style, P.Class, P.ListPrice
FROM        Production.Product P INNER JOIN
            Production.ProductSubcategory PS INNER JOIN
            Production.ProductCategory PC ON PS.ProductCategoryID = PC.ProductCategoryID ON P.ProductSubcategoryID = PS.ProductSubcategoryID INNER JOIN
            Production.ProductProductPhoto PPP ON P.ProductID = PPP.ProductID INNER JOIN
            Production.ProductPhoto PP ON PPP.ProductPhotoID = PP.ProductPhotoID LEFT OUTER JOIN
            Production.ProductDescription PD INNER JOIN
            Production.ProductModel PM INNER JOIN
            Production.ProductModelProductDescriptionCulture PMPDCL ON PM.ProductModelID = PMPDCL.ProductModelID ON 
            PD.ProductDescriptionID = PMPDCL.ProductDescriptionID ON P.ProductModelID = PM.ProductModelID
WHERE       (PMPDCL.CultureID = @Language)

Collapse image See also


About this documentation