In SCRM 2006, SCRS_GetAdvertisementProgramName gets a list of SMS program names for an SMS advertisement.
SCRS_GetAdvertisementProgramName @LocaleID, [@PackageName=]'<ALL>'
Arguments
@LocaleID
Type: int
Locale identifier for the installed product.
@PackageName
Type: nvarchar
Value for conditioning query against SCRM 2006 SCRS_Package_Dimension_View.PackageName.
Return Code
Type: int
Value: Always 0.
Results Sets
| Column name | Data Type | Description |
|---|---|---|
AdvertisementProgramName |
String |
Output value from SCRM 2006 SCRS_Advertisement_Dimension_View.AdvertisementProgramName. |
AdvertisementProgramNameLabel |
String |
Output value from SCRM 2006 SCRS_Advertisement_Dimension_View.AdvertisementProgramName. |
See Also
Other Resources
Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures