UFN_REVENUE_NOTACKNOWLEDGED

Returns all revenue records that have not been acknowledged.

Return

Return Type
table

Definition

Copy



        CREATE function dbo.UFN_REVENUE_NOTACKNOWLEDGED()
        returns table
        as return

        select 
        REVENUE.ID 
    from 
      dbo.REVENUE              
        where 
      REVENUE.ID not in (select REVENUELETTER.REVENUEID from dbo.REVENUELETTER)