USP_FAFTHEMESTYLESHEET_DATALIST

CREATE procedure dbo.USP_FAFTHEMESTYLESHEET_DATALIST
@THEMEID as uniqueidentifier
as
    set nocount on;

  select B.STYLESHEETID, A.NAME, B.SEQUENCE, C.LAYOUTID, isnull(D.CONTENT, '') CONTENT
    from SITESTYLESHEETS A (nolock)
    inner join THEMESTYLESHEET B (nolock) on A.ID = B.STYLESHEETID
    inner join THEME C (nolock) on C.ID = B.THEMEID
    left outer join SITELAYOUTS D (nolock) on D.ID = C.LAYOUTID
   where B.THEMEID = @THEMEID order by B.SEQUENCE desc