UFN_PROGRAMCATEGORYCODE_ASSOICATEDSITES

create function dbo.UFN_PROGRAMCATEGORYCODE_ASSOICATEDSITES
(
    @PROGRAMCATEGORYCODEID uniqueidentifier
)
returns xml
with execute as caller
as begin

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

end