Share via


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