# \#circ\_trans

**URL:** https://forum.innovativeusers.org/tag/circ-trans/125.md

[Latest](https://forum.innovativeusers.org/latest.md) · [Categories](https://forum.innovativeusers.org/categories.md) · [Tags](https://forum.innovativeusers.org/tags.md)

---

## [SQL Query Batch for Analysis of Checkouts by Branch](https://forum.innovativeusers.org/t/sql-query-batch-for-analysis-of-checkouts-by-branch/2530)

<div class="topic-metadata">

**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 9\
**Last updated:** [June 7, 2026, 2:10pm UTC](https://forum.innovativeusers.org/t/sql-query-batch-for-analysis-of-checkouts-by-branch/2530 "2026-06-07T14:10:48Z")

</div>

Collection Health Holds.sql (54.7 KB) (latest version uploaded 2/22/2026) This “Collection Health Holds Query” has been in development for over two years now. I first mentioned it in this post and presented a snippet…

---

## [Holdshelf Status Query](https://forum.innovativeusers.org/t/holdshelf-status-query/2036)

<div class="topic-metadata">

**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 0\
**Last updated:** [October 8, 2024, 2:20pm UTC](https://forum.innovativeusers.org/t/holdshelf-status-query/2036 "2024-10-08T14:20:55Z")

</div>

This query started its life as a replacement for the Clear Expired Holds and Holdshelf report for one location. I’m posting it here in case anyone can benefit from the report or any of these query features: Use of CTE…