fnGetClientSite_UserDashboard

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@ClientSitesID int IN

Definition

Copy

CREATE FUNCTION [dbo].[fnGetClientSite_UserDashboard]
(
@ClientSitesID int
)
RETURNS int
AS
BEGIN

RETURN(    
SELECT 
TOP 1 ISNULL(ID, 0) 'SiteContentID'
FROM SiteContent 
WHERE  
--For now, lets look at all site b/c there is only one UNM per client ClientSitesID = @ClientSitesID AND
ContentTypesID = 104
)
END