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.