Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
|
|
0
|
2
|
May 9, 2025
|
Get a count of staff using Leap per branch
|
|
0
|
3
|
May 8, 2025
|
Find all transaction activity types for a patron ID
|
|
0
|
33
|
April 28, 2025
|
Intermediate SQL for Sierra and Polaris
|
|
0
|
103
|
March 19, 2025
|
Understanding CROSS APPLY and OUTER APPLY in SQL Server
|
|
0
|
37
|
April 23, 2025
|
You Saved Amounts - Minus Renewals
|
|
0
|
312
|
March 17, 2024
|
SMS statistics query
|
|
2
|
35
|
April 17, 2025
|
Understanding UNION and UNION ALL in SQL Server
|
|
3
|
47
|
April 9, 2025
|
Sample UNTESTED code for updating Polaris Patron Address Types
|
|
0
|
33
|
April 9, 2025
|
Understanding UNION and UNION ALL
|
|
0
|
18
|
April 7, 2025
|
Top Circulation by Shelf Location
|
|
1
|
31
|
April 4, 2025
|
Pull Record Set Information and Counts
|
|
0
|
21
|
April 4, 2025
|
Finds patrons who have Additional TXT/SMS enabled
|
|
0
|
36
|
April 2, 2025
|
Who Modified a Patron Registration
|
|
0
|
21
|
April 2, 2025
|
Round Prices to Stop Taking Money at Front Desk
|
|
0
|
9
|
April 2, 2025
|
Get Patron Mobile Carrier Info
|
|
0
|
21
|
April 2, 2025
|
Identifying Items With Inconsistent Location Code <–> Call Number Combinations
|
|
0
|
34
|
March 26, 2025
|
Adding User2 field above mailing address in print Billing and Overdue notices?
|
|
5
|
44
|
March 25, 2025
|
Dynamic T-SQL Script Parameterization Using Python
|
|
0
|
38
|
March 24, 2025
|
No Rapido-driven changes/additions to the Sierra database structure in version 6.4
|
|
0
|
26
|
March 21, 2025
|
Find Tool - Find records with duplicate OCLC numbers
|
|
5
|
54
|
March 15, 2025
|
Help with saving SQL hold shelf list in Leap?
|
|
2
|
39
|
January 26, 2025
|
Help with SSRS report to with query/prompt to work in the Polaris Toolbar
|
|
5
|
76
|
December 17, 2024
|
Boilerplate Code to Run a SQL Query from a Python Script
|
|
0
|
102
|
September 13, 2024
|
Resetting Due Dates Based on Current Due Date
|
|
0
|
37
|
October 30, 2024
|
Examine Patron and Item Cross Borrowing
|
|
0
|
27
|
October 30, 2024
|
Count of Items Created by User and Collection
|
|
0
|
33
|
October 30, 2024
|
SQL for collection check out by patron code
|
|
1
|
54
|
October 18, 2024
|
Find high priced item records
|
|
0
|
44
|
October 17, 2024
|
SQL for Duplicate Titles
|
|
3
|
158
|
October 10, 2024
|