I created a UDF to check for more than one instances of a value 1 in a bit column corresponding to a given ID in a table.
CREATE function [dbo].[udfDefault4Scheduling] (@intNPIID int)
returns bit
as
begin
declare @bit bit
set @bit = (select case when count(NPIID) <= 1 then 1 else 0 end from...
