|
SQL EXISTS Use Cases and Examples
|
|
0
|
11
|
October 23, 2025
|
|
You Saved Amounts - Minus Renewals
|
|
2
|
366
|
October 16, 2025
|
|
Hoopla ID mismatches: Find where 037$a and ID in hoopla URLs don't match
|
|
0
|
17
|
October 6, 2025
|
|
SQL to identify bibs with no 520 but matching other bibs with 245ab
|
|
0
|
27
|
October 3, 2025
|
|
Create Lists Cleanup Accountability
|
|
1
|
42
|
September 29, 2025
|
|
5-Way Sierra User Permissions Comparison Query
|
|
0
|
19
|
September 24, 2025
|
|
SQL Query Batch for Analysis of Checkouts by Branch
|
|
7
|
182
|
September 17, 2025
|
|
Round Prices to Stop Taking Money at Front Desk
|
|
7
|
49
|
August 28, 2025
|
|
How to create your custom GPT SQL Expert
|
|
1
|
96
|
August 15, 2025
|
|
Patrons With Outstanding Charges for Deleted Items
|
|
2
|
49
|
August 19, 2025
|
|
Circ Counts for All Items in a Record Set
|
|
0
|
54
|
July 24, 2025
|
|
ILL Item History by PatronID
|
|
0
|
11
|
July 18, 2025
|
|
Hold Counts - Patron Branch vs Pickup Branch
|
|
1
|
388
|
March 17, 2024
|
|
Deleted Items Billed and Overdue
|
|
5
|
47
|
June 27, 2025
|
|
Is there a SQL for average hold wait time?
|
|
3
|
329
|
June 5, 2025
|
|
Circulation Counts with Transaction Logs
|
|
1
|
57
|
May 14, 2025
|
|
Get a count of staff using Leap per branch
|
|
0
|
33
|
May 8, 2025
|
|
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
|
|
0
|
60
|
May 9, 2025
|
|
Find all transaction activity types for a patron ID
|
|
0
|
79
|
April 28, 2025
|
|
Intermediate SQL for Sierra and Polaris
|
|
0
|
147
|
March 19, 2025
|
|
Understanding CROSS APPLY and OUTER APPLY in SQL Server
|
|
0
|
122
|
April 23, 2025
|
|
SMS statistics query
|
|
2
|
67
|
April 17, 2025
|
|
Understanding UNION and UNION ALL in SQL Server
|
|
3
|
65
|
April 9, 2025
|
|
Sample UNTESTED code for updating Polaris Patron Address Types
|
|
0
|
35
|
April 9, 2025
|
|
Understanding UNION and UNION ALL
|
|
0
|
24
|
April 7, 2025
|
|
Top Circulation by Shelf Location
|
|
1
|
54
|
April 4, 2025
|
|
Pull Record Set Information and Counts
|
|
0
|
34
|
April 4, 2025
|
|
Finds patrons who have Additional TXT/SMS enabled
|
|
0
|
50
|
April 2, 2025
|
|
Who Modified a Patron Registration
|
|
0
|
36
|
April 2, 2025
|
|
Get Patron Mobile Carrier Info
|
|
0
|
30
|
April 2, 2025
|