USP_DONATIONBATCH_LOAD

CREATE procedure dbo.USP_DONATIONBATCH_LOAD
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    DONATIONBATCH.ID,BATCHID,SEQUENCE,EVENTID,USERID,PASSWORD,LASTNAME,FIRSTNAME,MIDDLENAME,TITLECODEID,SUFFIXCODEID,NICKNAME,MAIDENNAME,
          BIRTHDATE,GENDERCODE,MARITALSTATUSCODEID,ADDRESSTYPECODEID,COUNTRYID,ADDRESS,CITY,STATEID,POSTCODE,DONOTMAIL,
          DONOTMAILREASONCODEID,PHONETYPECODEID,PHONENUMBER,EMAILADDRESS,ISCOMPANYGIFT,COMPANYNAME,COMPANYURL,COMPANY_ADDRESSTYPECODEID,
          COMPANY_COUNTRYID,COMPANY_ADDRESS,COMPANY_CITY,COMPANY_STATEID,COMPANY_POSTCODE,COMPANY_DONOTMAIL,COMPANY_DONOTMAILREASONCODEID,
          COMPANY_PHONETYPECODEID,COMPANY_PHONENUMBER,COMPANY_EMAILADDRESS,GIFTTYPE,GIFTAMOUNT,NUMPAYMENTS,FREQUENCY,AUTOINSTALLMENTS,
          ANONYMOUS,STARTDATE,INFINITEGIFT,PAYMENTMETHODCODE,
      CREDITCARD.CARDHOLDERNAME as CREDITCARDHOLDER,CREDITCARD.CREDITCARDPARTIALNUMBER as CREDITCARDNUMBER,
      CREDITCARDTYPE, CREDITCARD.EXPIRESON as EXPIRATIONDATE, CREDITCARD.CREDITCARDTOKEN, CREDITCARDID,
          CHECKDATE,CHECKNUMBER,BANKACCOUNTTYPECODE,BANKACCOUNTHOLDER,BANKACCOUNTNUMBER,BANKACCOUNTROUTINGCODE,SAMEASPRIMARYADDRESS,
          BILLING_ADDRESSTYPECODEID,BILLING_COUNTRYID,BILLING_ADDRESSBLOCK,BILLING_CITY,BILLING_STATEID,BILLING_POSTCODE,SHOWTRIBUTE,
          TRIBUTEFIRSTNAME,TRIBUTELASTNAME,TRIBUTEEMAIL,TRIBUTEADDRESS,TRIBUTECITY,TRIBUTEPOSTCODE,TRIBUTESTATEID,
          TRIBUTETYPECODEID,TRIBUTETEXT,TRIBUTEANONYMOUS,ACKNOWLEDGEFIRSTNAME,ACKNOWLEDGELASTNAME,ACKNOWLEDGEEMAIL,
          MESSAGETOACKNOWLEDGE,RECOGNITIONCREDIT,MATCHINGCOMPANYNAME,MATCHINGAMOUNT,RECIPIENTGROUPID,RECIPIENTREGISTRANTID,RECIPIENTROLE,SENDTOACKNOWLEDGE,
      SAVETRIBUTEEASCONSTITUENT, ORIGINALCLIENTUSERID, ORIGINALCONSTITUENTID, PHONEID, ADDRESSID, EMAILADDRESSID,
      ORGANIZATIONCONSTITUENTID
  from DONATIONBATCH (nolock)
  left outer join dbo.CREDITCARD (nolock) on DONATIONBATCH.CREDITCARDID = CREDITCARD.ID
  where DONATIONBATCH.ID=@ID