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