This is my final entry in the series on SQL queries for Patron Edge. Today let’s take a look at the access control tables, so we can do some cool stuff with barcode scanning results: select * from Barcodes_Log inner join Barcodes on Barcodes.brtSourceCode = Barcodes_Log.brtlCrossRefID and Barcodes.brtSourceTable...

Continuing on yesterday’s theme, here are a few more tables and joins to do with what you will. We’ll start with the SubsStaticReport table this time, which is a data warehouse table that contains all of your subscriptions and memberships. select * from SubsStaticReport inner join Clients on Clients...

While giving a session at the Museum Computer Network conference on extracting data from a Patron Edge database, one of the attendees suggested creating a handful of sample queries. The idea is that with some samples showing the important table joins, users can run with them, expand on them, or even...

Windows Server 2008 has been out for a while and it’s easier to move your Blackbaud product(s) to a new server than to continue maintaining the old server. After moving to a new server some of you may have trouble connecting your Blackbaud application to the new SQL Server. Workstations may get the error...