SalesByCategory
Parameters
Parameter name | Ordinal | Native type | Length | Precision | Scale | Direction | Is result-set |
---|---|---|---|---|---|---|---|
@CategoryName | 1 | nvarchar | 15 | 0 | 0 | Input | |
@OrdYear | 2 | nvarchar | 4 | 0 | 0 | Input |
Model elements mapped on this stored procedure
Model Element | Element type |
---|---|
SalesByCategory | Stored Procedure Call |
Result sets
Resultset1
Fields
Field name | Ordinal | Native type | Length | Precision | Scale | Is Nullable |
---|---|---|---|---|---|---|
ProductName | 1 | nvarchar | 40 | 0 | 0 | |
TotalPurchase | 2 | decimal | 0 | 38 | 2 | Yes |
Model elements mapped on this resultset
None.