USP_DATALIST_MICROSITEDESIGNATIONS_BYCONTENTID
Lists the designations given a CMS donation form sitecontent ID
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CONTENTID | int | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_MICROSITEDESIGNATIONS_BYCONTENTID(@CONTENTID int)
as
set nocount on;
declare @DESIGNATIONID uniqueidentifier
select @DESIGNATIONID=OBJECTID
from dbo.MICROSITEPAGE
where PRIMARYCONTENTID = @CONTENTID
exec dbo.USP_DATALIST_MICROSITEDONATIONDESIGNATIONS @DESIGNATIONID