spClientSites

    CREATE PROCEDURE [dbo].[spClientSites]
    (
    @ClientsID int
    )
    AS

    SELECT
    ID,
    [NAME],
    DELETED,    
    [GUID],
    PARENTSITEID,    
    1 as HASRIGHTS,
    dbo.UFN_CLIENTSITE_ISPUBLISHED(ID) as PUBLISHED
    FROM
    dbo.ClientSites
    order by [NAME] ASC