spGetSiteStyleSheet

            CREATE  PROCEDURE [dbo].[spGetSiteStyleSheet] (
            @StyleSheetID  int
            )
            AS

            EXEC dbo.USP_GET_KEY_ACCESS;
            SELECT     dbo.CSSClasses.ClassName, dbo.CSSClasses.BBDefaultCSS, dbo.CSSClasses.Description, dbo.CSSClasses.InheritsClass,
            dbo.CSSClasses.FriendlyName, InheritedClasses.FriendlyName AS InheritedFriendlyName, InheritedClasses.BBDefaultCSS AS SystemInheritedCSS,
            dbo.CSSClasses.ContentTypeID, ct.Name AS PartTypeName, InheritedClasses.ID AS InheritedClassId,
            dbo.CSSClasses.ID AS cssClassId, InheritedStyleSheetClasses.css AS SheetInheritedCSS, fnStyleSheetClasses_1.css,
            fnStyleSheetClasses_1.id

            FROM
            dbo.vwContentTypes ct INNER JOIN
            dbo.ClientContentTypes ON ct.ID = dbo.ClientContentTypes.ContentTypesID RIGHT OUTER JOIN
            dbo.CSSClasses LEFT OUTER JOIN
            dbo.fnStyleSheetClasses(@stylesheetid) fnStyleSheetClasses_1 ON dbo.CSSClasses.ID = fnStyleSheetClasses_1.cssclassid ON
            ct.ID = dbo.CSSClasses.ContentTypeID LEFT OUTER JOIN
            dbo.fnStyleSheetClasses(@stylesheetid) InheritedStyleSheetClasses RIGHT OUTER JOIN
            dbo.CSSClasses InheritedClasses ON InheritedStyleSheetClasses.cssclassid = InheritedClasses.ID ON
            dbo.CSSClasses.InheritsClass = InheritedClasses.ClassName
            LEFT JOIN dbo.INSTALLEDPRODUCTLIST ipl ON ct.Flag = convert(nvarchar(36), ipl.ID)
            where (CSSClasses.ContentTypeID<=0) or ((CSSClasses.ContentTypeID>0) and ct.Name is not null)
            AND (dbo.CSSClasses.ContentTypeID<1 or ipl.ID is not null OR ct.Flag is null)
            and coalesce(ct.Hidden, 0)=0
            ORDER BY dbo.CSSClasses.ContentTypeID, dbo.CSSClasses.InheritsClass, dbo.CSSClasses.ID

          CLOSE symmetric key sym_BBInfinity