UFN_MEMBERSHIP_GETTODAYSMEMBERSHIPSALES

        create function dbo.UFN_MEMBERSHIP_GETTODAYSMEMBERSHIPSALES()
        returns integer
        with execute as caller
        as begin
            declare @FROMDATE datetime = (select dbo.UFN_DATE_GETEARLIESTTIME(getdate()))
            declare @TODATE datetime = (select dbo.UFN_DATE_GETLATESTTIME(getdate()))

            return (
                select
                    count(MS.ID) 
                from dbo.SALESORDERITEM SOI
                inner join dbo.SALESORDERITEMMEMBERSHIP SOIM on SOI.ID = SOIM.ID
                inner join dbo.SALESORDER SO on SO.ID = SOI.SALESORDERID
                inner join dbo.MEMBERSHIP MS on SOIM.MEMBERSHIPID = MS.ID
                where MS.STATUSCODE <> 1
                and SO.TRANSACTIONDATE between @FROMDATE and @TODATE
            )
        end