USP_BATCHEVENTSPONSORSHIP_LOAD

CREATE procedure dbo.USP_BATCHEVENTSPONSORSHIP_LOAD
(
  @ID uniqueidentifier
)
as

    set nocount on;

    select
     BATCHEVENTSPONSORSHIP.ID, BATCHID, SEQUENCE, EVENTID, ORIGINALCLIENTUSERID, USERID, PASSWORD, ORIGINALCONSTITUENTID, PHONEID, ADDRESSID, EMAILADDRESSID, LASTNAME, FIRSTNAME, MIDDLENAME, TITLECODEID, SUFFIXCODEID, NICKNAME,
     MAIDENNAME, BIRTHDATE, GENDERCODE, MARITALSTATUSCODEID, ADDRESSTYPECODEID, COUNTRYID, ADDRESS, CITY, STATEID, POSTCODE,
     DONOTMAIL, DONOTMAILREASONCODEID, PHONETYPECODEID, PHONENUMBER, EMAILADDRESS, ISCOMPANYSPONSOR, ORGANIZATIONCONSTITUENTID, COMPANYNAME, COMPANYURL, COMPANY_ADDRESSTYPECODEID,
     COMPANY_COUNTRYID, COMPANY_ADDRESS, COMPANY_CITY, COMPANY_STATEID, COMPANY_POSTCODE, COMPANY_DONOTMAIL, COMPANY_DONOTMAILREASONCODEID,
     COMPANY_PHONETYPECODEID, COMPANY_PHONENUMBER, COMPANY_EMAILADDRESS, SPONSORSHIPTYPEID, DECLINEBENEFITS, SPONSORSHIPURL, SPONSORSHIPMESSAGE,
     ADDITIONALDONATIONAMOUNT, PAYMENTMETHODCODE, 
     CREDITCARD.CARDHOLDERNAME as CREDITCARDHOLDER, CREDITCARD.CREDITCARDPARTIALNUMBER as CREDITCARDNUMBER, 
     CREDITCARDTYPE, CREDITCARD.EXPIRESON as EXPIRATIONDATE, CREDITCARD.CREDITCARDTOKEN, CREDITCARDID,
     CHECKNUMBER, CHECKDATE, BANKACCOUNTTYPECODE, BANKACCOUNTHOLDER, BANKACCOUNTNUMBER, BANKACCOUNTROUTINGCODE, SAMEASPRIMARYADDRESS, BILLING_ADDRESSTYPECODEID,
     BILLING_COUNTRYID, BILLING_ADDRESSBLOCK, BILLING_CITY, BILLING_STATEID, BILLING_POSTCODE
  from BATCHEVENTSPONSORSHIP (nolock)
  left outer join dbo.CREDITCARD (nolock) on BATCHEVENTSPONSORSHIP.CREDITCARDID = CREDITCARD.ID
  where BATCHEVENTSPONSORSHIP.ID = @ID