Sales by Year
Parameters
| Parameter name | Ordinal | Native type | Length | Precision | Scale | Direction | Is result-set |
|---|---|---|---|---|---|---|---|
| @Beginning_Date | 1 | datetime | 0 | 0 | 0 | Input | |
| @Ending_Date | 2 | datetime | 0 | 0 | 0 | Input |
Model elements mapped on this stored procedure
| Model Element | Element type |
|---|---|
| SalesByYear | Stored Procedure Call |
Result sets
Resultset1
Fields
| Field name | Ordinal | Native type | Length | Precision | Scale | Is Nullable |
|---|---|---|---|---|---|---|
| ShippedDate | 1 | datetime | 0 | 0 | 0 | Yes |
| OrderID | 2 | int | 0 | 10 | 0 | |
| Subtotal | 3 | money | 0 | 19 | 4 | Yes |
| Year | 4 | nvarchar | 30 | 0 | 0 | Yes |
Model elements mapped on this resultset
None.