SCRS_GetAdvertisementProgramName Stored Procedure

  • Article

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