# SQL Query Batch for Analysis of Checkouts by Branch

**URL:** https://forum.innovativeusers.org/t/sql-query-batch-for-analysis-of-checkouts-by-branch/2530
**Category:** Sierra Repository
**Tags:** checkouts, sierra-sql, holds, sql, circ\_trans
**Created:** [June 27, 2025, 6:51pm UTC](https://forum.innovativeusers.org/t/sql-query-batch-for-analysis-of-checkouts-by-branch/2530 "2025-06-27T18:51:25Z")
**Posts on this page:** 1
**Showing post:** 11

<div class="post-metadata">

### Author: ![bgaydos](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/bgaydos/32/1045_2.png) [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)
#### Post date: [June 7, 2026, 2:10pm UTC](https://forum.innovativeusers.org/t/sql-query-batch-for-analysis-of-checkouts-by-branch/2530/11 "2026-06-07T14:10:48Z")

</div>

Please see **[this post](https://forum.innovativeusers.org/t/understanding-partition-by-in-sql-server-and-postgresql/2962)** for an article explaining the use of PARTITION BY in the window functions used in this query.

---

_[View the full topic](https://forum.innovativeusers.org/t/sql-query-batch-for-analysis-of-checkouts-by-branch/2530)._