Topics tagged sql

Topic	Replies	Views	Activity
SQL Query Batch for Analysis of Checkouts by Branch Sierra Repository holds , sierra-sql , checkouts , sql , circ_trans	8	293	February 22, 2026
Round Prices to Stop Taking Money at Front Desk Polaris Repository polaris , sql , polaris-sql	12	130	February 3, 2026
Browse vs Holds Circulation Polaris Repository sql , polaris-items	4	441	January 9, 2026
Minuteman Script Repository Sierra Repository automation , python , sql	0	56	December 31, 2025
Bulk waive SQL query for 7.8 help Polaris sql	10	136	December 18, 2025
Who Modified a Patron Registration Polaris Repository polaris , sql , polaris-sql	1	91	November 3, 2025
SQL EXISTS Use Cases and Examples Polaris Repository sql , sql-server , polaris-sql , mssqltips , exists	0	60	October 23, 2025
You Saved Amounts - Minus Renewals Polaris Repository polaris-patrons , sql , polaris-items , polaris-circ	2	423	October 16, 2025
Hoopla ID mismatches: Find where 037$a and ID in hoopla URLs don't match Polaris Repository sql , polaris	0	32	October 6, 2025
SQL to identify bibs with no 520 but matching other bibs with 245ab Sierra, Millennium & Encore sql	0	44	October 3, 2025
Create Lists Cleanup Accountability Sierra Repository sierra-sql , sql , create-lists , review-files , sierra-users	1	61	September 29, 2025
5-Way Sierra User Permissions Comparison Query Sierra Repository permissions , sierra-sql , sierra , sql , comparator	0	31	September 24, 2025
How to create your custom GPT SQL Expert General sierra-sql , sql , polaris-sql , chatgpt , skynet-apocalypse	1	132	August 15, 2025
Patrons With Outstanding Charges for Deleted Items Polaris Repository sql , polaris-sql	2	95	August 19, 2025
Circ Counts for All Items in a Record Set Polaris Repository polaris-circ , sql , polaris-sql	0	96	July 24, 2025
ILL Item History by PatronID Clearinghouse Repository sql , polaris-sql , interlibrary-loan	0	41	July 18, 2025
Hold Counts - Patron Branch vs Pickup Branch Polaris Repository polaris-holds , sql	1	410	March 17, 2024
Deleted Items Billed and Overdue Polaris Repository sql , polaris-sys-admin , polaris-sql , polaris	5	93	June 27, 2025
Is there a SQL for average hold wait time? Polaris polaris , sql	3	357	June 5, 2025
Circulation Counts with Transaction Logs Polaris polaris-circ , leap , sql	1	100	May 14, 2025
Get a count of staff using Leap per branch Clearinghouse Repository polaris , leap , sql	0	47	May 8, 2025
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD Polaris Repository sql-server , polaris-sql , sql-server-central , sql , date-time-arithmetic	0	80	May 9, 2025
Find all transaction activity types for a patron ID Polaris Repository polaris-patrons , polaris , sql	0	107	April 28, 2025
Intermediate SQL for Sierra and Polaris IUG Conference 2025 sql , iug-2025	0	162	March 19, 2025
Understanding CROSS APPLY and OUTER APPLY in SQL Server Polaris Repository sql-server , polaris-sql , sql-server-central , sql , apply	0	150	April 23, 2025
SMS statistics query Polaris polaris , sql	2	88	April 17, 2025
Understanding UNION and UNION ALL in SQL Server Polaris union , polaris-sql , sql , sql-server-central , union-all	3	82	April 9, 2025
Sample UNTESTED code for updating Polaris Patron Address Types Polaris Repository sql	0	49	April 9, 2025
Understanding UNION and UNION ALL Sierra, Millennium & Encore sierra-sql , union , sql , sql-server-central , union-all	0	38	April 7, 2025
Top Circulation by Shelf Location Polaris Repository polaris , sql , polaris-sql	1	93	April 4, 2025