fnGetNotificationIDByTypeAndSiteContentID

                  CREATE FUNCTION [dbo].[fnGetNotificationIDByTypeAndSiteContentID]
                  (
                  @NotificationTypeID int,
                  @SiteContentID int
                  )
                  RETURNS int
                  AS

                  BEGIN
                  RETURN
                  (SELECT n.ID
                  FROM dbo.NC_Notification n
                  INNER JOIN Notification_SiteContent nsc ON nsc.NotificationID = n.ID AND nsc.SiteContentID = @SiteContentID
                  WHERE
                  n.NotificationTypeID = @NotificationTypeID AND n.Enabled = 1)
                  END