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