USP_DATALIST_THEMESTYLESHEET

Returns all Theme Stylesheet records for a given Theme.

Parameters

Parameter	Parameter Type	Mode	Description
@THEMEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_THEMESTYLESHEET (@THEMEID uniqueidentifier)
as
    set nocount on;

    select 
        THEMESTYLESHEET.[ID],
        THEMESTYLESHEET.[THEMEID],
        THEMESTYLESHEET.[STYLESHEETID],
        THEMESTYLESHEET.[SEQUENCE],
        CSS.NAME
    from 
        dbo.THEMESTYLESHEET inner join
        dbo.SiteStyleSheets css on THEMESTYLESHEET.STYLESHEETID = css.id
  where 
        THEMESTYLESHEET.[THEMEID] = @THEMEID
  order by THEMESTYLESHEET.[SEQUENCE]