fnGetDefaultSiteURL

CREATE FUNCTION dbo.fnGetDefaultSiteURL
(
)
RETURNS nvarchar(255)
AS
BEGIN
    declare @DefaultSiteID int
    set @DefaultSiteID = (select Value from dbo.Setting where ID = 1)    
    return (select VALUE from dbo.CMSSITESETTING where CLIENTSITESID = @DefaultSiteID and ENUMID = 11)

END