USE [DataPRO] GO /****** Object: UserDefinedFunction [dbo].[foo_GetTotalChannelCount] Script Date: 1/25/2019 2:35:50 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[foo_GetTotalChannelCount] ( @GroupId int ) RETURNS int AS BEGIN return (SELECT COUNT(*) FROM [DataPro].[dbo].[Channels] WHERE GroupId = @GroupId) END GO