UFN_EVENTCATEGORYCODE_ASSOCIATEDSITES

create function dbo.UFN_EVENTCATEGORYCODE_ASSOCIATEDSITES
(
    @EVENTCATEGORYCODEID uniqueidentifier
)
returns xml
with execute as caller
as begin

return
(
    select
        EVENTCATEGORYCODESITE.SITEID
    from
        dbo.EVENTCATEGORYCODESITE
    where
        EVENTCATEGORYCODESITE.EVENTCATEGORYCODEID = @EVENTCATEGORYCODEID
    for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
)

end