Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.

Create a SQL query using RODBA.

Contact your Account Manager for more information on this and other services offered at solutions@blackbaud.com or call (800) 443-9441.
 

Alternative solution:

  1. Create a constituent query of the appropriate constituents.
  2. Create a constituent export in Excel or Comma-Separated Value format. On the Output tab, select in this order:
    • Constituent Information > Import ID
    • Constituent Information > Last Name
    • Spouse > Biographical  > Last Name
       
  3. Open the export file in Excel.
  4. Delete the first row if it contains headers.
  5. Place the cursor in cell D1 and enter the following:

    =IF(B1=C1,"Yes","No")
     

  6. Copy this all the way down Column D.
  7. Sort the spreadsheet by this column.
  8. If you are looking for spouses whose last names are the same, delete all of the Nos. If you are looking for spouses whose last names are different, delete all of the Yeses.
  9. Place the cursor in cell A1, insert a row, and enter the following in cell A1: ImportID.
  10. Save the file in Comma-Separated Value (CSV) format.
  11. In The Raiser's Edge, click Admin, Import.
  12. Create a new constituent import.
  13. On the General tab, select Update existing records and browse to and select the file created above. On the Summary tab, select Create an output query of the records updated. Leave everything else set to the defaults.
  14. Click Import Now. When prompted, name the query. This is the query of the spouses whose names are the same (or different).