SCRS_GetValuesForSoftwareUpdateOptionALL Stored Procedure
In SCRM 2006, SCRS_GetValuesForSoftwareUpdateOptionALL gets a list of SWU options: Qnumbers, Bulletin ID, or Title, with the <ALL> option added.
SCRS_GetValuesForSoftwareUpdateOptionALL @LocaleID
,[ @ScanType = ] '<ALL>'
, @Option
Arguments
@LocaleID
Type: int
Locale identifier for the installed product.
@ScanType
Type: nvarchar
Value for conditioning query against SCRM 2006 SCRS_SoftwareUpdate_Dimension_View.SoftwareUpdateType.
@Option
Type: nvarchar
QNumbers, Bulletin ID, or Title, depending on desired output of procedure.
Return Code
Type: int
Value: Always 0.
Result Sets
| Column name | Data Type | Description |
|---|---|---|
SoftwareUpdateValue |
String |
Output value from SCRM 2006 SCRS_SoftwareUpdate_Dimension_View.SoftwareUpdateBulletinID, SoftwareUpdateQNumbers, or SoftwareUpdateTitle. |
SoftwareUpdateValueLabel |
String |
Output value from SCRM 2006 SCRS_SoftwareUpdate_Dimension_View.SoftwareUpdateBulletinID, SoftwareUpdateQNumbers, or SoftwareUpdateTitle. |
See Also
Other Resources
Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures