UFN_BBNC_TRANSACTION_GETDATEADDED

      create function dbo.UFN_BBNC_TRANSACTION_GETDATEADDED
      (
       @BBNCTRANID int,
       @TRANSACTIONTYPE uniqueidentifier
      )
      returns datetime
      with execute as caller
      as 
      begin
          declare @DATEADDED datetime;

          --donations

          if @TRANSACTIONTYPE = '{5705B543-4033-4a3a-BBCD-A731403EE1E6}'
          begin
              select 
                  @DATEADDED = DateAdded
              from 
                  dbo.DonationTransactions dt inner join 
                  dbo.Transactions t on dt.DonationTransactionsID = t.TransactionID
              where 
                  t.ID = @BBNCTRANID
          end

          --signups

          if @TRANSACTIONTYPE = '{5F84002B-ABB1-4f50-A244-D4B14FBB1579}'
          begin
              select 
                  @DATEADDED = DateAdded
              from 
                  dbo.SignupTransactions st inner join 
                  dbo.Transactions t on st.SignupTransactionsID = t.TransactionID
              where 
                  t.ID = @BBNCTRANID
          end

          --event regs

          if @TRANSACTIONTYPE = '{172A5D9A-5241-493C-A2C2-EAC164C095B0}'
          begin
              select
                  @DATEADDED = DateAdded
              from 
                  dbo.EventTransactions et inner join 
                  dbo.Transactions t on et.EventTransactionsID = t.TransactionID
              where 
                  t.ID = @BBNCTRANID
          end

          --profile updates

          if @TRANSACTIONTYPE = '{DCEAFCC7-0290-488E-A194-953DE66D6AAB}'
          begin
              select
                  @DATEADDED = DateLastChanged
              from 
                  dbo.ProfileUpdateTransactions pt inner join 
                  dbo.Transactions t on pt.ProfileUpdateTransactionsID = t.TransactionID
              where 
                  t.ID = @BBNCTRANID
          end

          return @DATEADDED;    
      end