Stay always connected!
  1. Martha Walters
  2. Sierra/ Millennium/ Encore
  3. Wednesday, 11 January 2017
  4.  Subscribe via email

I was wondering if anyone out there has a SQL query to identify when a branch has multiple copies of a title based on location code. For instance, we'd like to know when we have 2 or more copies of any adult non-fiction title at one particular branch so we can make decisions about moving or weeding those extra copies. An added bonus would be if it could also tell us when those multiple copies are not owned by any other branch but that is icing on the cake. I used to run these reports in Horizon quite often and it was very helpful in re-balancing the collection.

Thanks for any help.
Martha Walters
System Administrator
Palo Alto City Library
Palo Alto, CA
There are no comments made yet.

There are no replies made for this post yet.
Be one of the first to reply to this post!