fnGetUserImageCount

            CREATE FUNCTION [dbo].[fnGetUserImageCount]
                (
                @ClientSitesID int,
                @OwnerID int
                ) 
            RETURNS INT
            AS
            BEGIN
                RETURN 
                (SELECT COUNT(ID)
                   FROM dbo.SiteImages
                  WHERE ClientSitesID = @ClientSitesID
                    AND OwnerID = @OwnerID
                    AND Deleted = 0)
            END