spGetStyleSheetsForContent

CREATE Procedure dbo.spGetStyleSheetsForContent 
(
        @ContentID int
)
AS

    select distinct
    SiteContentID,
    dbo.fnGetStyleSheetForPage(sp.templatePageID, sp.templateid) StylesheetID
    from PageContent pc
    inner join sitepages sp on pc.SitePagesID = sp.id 
    and pc.SiteContentid=@ContentID