UFN_GETCMSALLOTHERSITEURLS

CREATE FUNCTION [dbo].[UFN_GETCMSALLOTHERSITEURLS]
    (
  @CLIENTSITESID int
    )
RETURNS @CMSAllOtherSiteURLs TABLE (
    [URL] nvarchar(255),
    [CLIENTSITESID] int,
  [ISPRIMARYSITEURL] bit
)
AS 
begin

    INSERT INTO @CMSAllOtherSiteURLs
    SELECT  V.URL,
                V.CLIENTSITESID,
            V.ISPRIMARYSITEURL
    FROM
      (SELECT 
          URL,
          CLIENTSITESID,
      0 AS ISPRIMARYSITEURL
      FROM    
          dbo.CMSSiteURLs    
    WHERE CLIENTSITESID<>@CLIENTSITESID
    UNION
    SELECT VALUE AS URL,
             CLIENTSITESID,
         1 AS ISPRIMARYSITEURL
      FROM dbo.CMSSITESETTING
    WHERE ENUMID = 11 and CLIENTSITESID<>@CLIENTSITESID
    ) AS V
    ORDER BY LEN(URL) DESC, V.ISPRIMARYSITEURL DESC

return 
end