UFN_BILLINGCYCLE_GETBILLINGCYCLEBYDATE

            CREATE function dbo.UFN_BILLINGCYCLE_GETBILLINGCYCLEBYDATE
            (
                @ASOFDATE date = null
            )
            returns varchar(8000)
            with execute as caller
            as begin
                declare @BillingCycle varchar(8000)

                if not @ASOFDATE is null
                begin
                    declare @BILLINGCYCLENAMES table
                    (
                        NAME nvarchar(100)
                    );

                    insert into @BILLINGCYCLENAMES
                        (NAME)
                    select BILLINGCYCLES.NAME
                        from dbo.UFN_GETBILLINGCYCLES() as BILLINGCYCLES
                        where (@ASOFDATE between BILLINGCYCLES.BILLINGSTARTDATE and BILLINGCYCLES.BILLINGENDDATE)
                        order by BILLINGCYCLES.NAME;

                    if ((select count(BILLINGCYCLENAMES.NAME) from @BILLINGCYCLENAMES as BILLINGCYCLENAMES) > 0)
                    begin
                        select @BillingCycle =dbo.UDA_BUILDLISTWITHDELIMITER(BILLINGCYCLENAMES.NAME, '; ')
                            from @BILLINGCYCLENAMES as BILLINGCYCLENAMES;
                    end
                    else
                    begin
                        set @BillingCycle = '';
                    end
                end

                return @BillingCycle 
            end