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	3	75	July 10, 2025
Hold Counts - Patron Branch vs Pickup Branch Polaris Repository polaris-holds , sql	1	378	March 17, 2024
Deleted Items Billed and Overdue Polaris Repository sql , polaris-sys-admin , polaris-sql , polaris	5	34	June 27, 2025
Is there a SQL for average hold wait time? Polaris polaris , sql	3	316	June 5, 2025
Circulation Counts with Transaction Logs Polaris polaris-circ , leap , sql	1	51	May 14, 2025
Get a count of staff using Leap per branch Clearinghouse Repository polaris , leap , sql	0	32	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	52	May 9, 2025
Find all transaction activity types for a patron ID Polaris Repository polaris-patrons , polaris , sql	0	64	April 28, 2025
Intermediate SQL for Sierra and Polaris IUG Conference 2025 sql , iug-2025	0	127	March 19, 2025
Understanding CROSS APPLY and OUTER APPLY in SQL Server Polaris Repository sql-server , polaris-sql , sql-server-central , sql , apply	0	102	April 23, 2025
You Saved Amounts - Minus Renewals Polaris Repository polaris-patrons , sql , polaris-items , polaris-circ	0	333	March 17, 2024
SMS statistics query Polaris polaris , sql	2	49	April 17, 2025
Understanding UNION and UNION ALL in SQL Server Polaris union , polaris-sql , sql , sql-server-central , union-all	3	58	April 9, 2025
Sample UNTESTED code for updating Polaris Patron Address Types Polaris Repository sql	0	35	April 9, 2025
Understanding UNION and UNION ALL Sierra, Millennium & Encore sierra-sql , union , sql , sql-server-central , union-all	0	18	April 7, 2025
Top Circulation by Shelf Location Polaris Repository polaris , sql , polaris-sql	1	44	April 4, 2025
Pull Record Set Information and Counts Polaris Repository polaris-sys-admin , record-sets , polaris-sql , sql	0	23	April 4, 2025
Finds patrons who have Additional TXT/SMS enabled Polaris Repository polaris , sql	0	44	April 2, 2025
Who Modified a Patron Registration Polaris Repository polaris , sql , polaris-sql	0	22	April 2, 2025
Round Prices to Stop Taking Money at Front Desk Polaris Repository polaris , sql , polaris-sql	0	11	April 2, 2025
Get Patron Mobile Carrier Info Polaris Repository polaris , sql	0	26	April 2, 2025
Identifying Items With Inconsistent Location Code <–> Call Number Combinations Sierra Repository sierra-sql , sql , item-record , audience , discrepancy	0	46	March 26, 2025
Adding User2 field above mailing address in print Billing and Overdue notices? Polaris notices , sql	5	61	March 25, 2025
Dynamic T-SQL Script Parameterization Using Python Polaris sql-server , sql , iug-2025 , python , polaris-sql	0	44	March 24, 2025
No Rapido-driven changes/additions to the Sierra database structure in version 6.4 Sierra, Millennium & Encore sql , sierra , rapido , sierra-64 , ohio	0	27	March 21, 2025
Find Tool - Find records with duplicate OCLC numbers Polaris Repository sql , polaris	5	94	March 15, 2025
Help with saving SQL hold shelf list in Leap? Polaris sql	2	40	January 26, 2025
Help with SSRS report to with query/prompt to work in the Polaris Toolbar Polaris ssrs , report , sql	5	78	December 17, 2024
Boilerplate Code to Run a SQL Query from a Python Script Sierra, Millennium & Encore sql , sierra , python , psycopg2 , column-metadata	0	112	September 13, 2024
Resetting Due Dates Based on Current Due Date Polaris Repository polaris-circ , polaris-items , sql	0	38	October 30, 2024