Dataset: CategoryQuotas
Property | Value |
Data source name | AdventureWorks |
Referenced data set | |
Command type | Query |
Name | Source column | Data type | Caption | Value | Is calculated field |
ID | ID | System.Int32 | |||
Category | Category | System.String | |||
Quota | Quota | System.Int32 | |||
PercentDeviation | PercentDeviation | System.Int32 | |||
QuotaF |
SELECT 1 as ID, 'Accessories' as Category, 1000 as Quota, 25 as PercentDeviation UNION SELECT 2 as ID, 'Bikes' as Category, 70000 as Quota, 5 as PercentDeviation UNION SELECT 3 as ID, 'Clothing' as Category, 2500 as Quota, 20 as PercentDeviation UNION SELECT 4 as ID, 'Components' as Category, 20000 as Quota, 10 as PercentDeviation |