Category Archives: Programming/Coding

Finding Date Closest to Middle or Last Day of Month in SQL

If you have ever worked in SQL or other databases you know that dates can be very tricky. It is not always simple to capture differences and length of time …

Tags: , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Generating Random Strings in SQL

The other day I was requested to add records to a lookup table only if the description being added didn’t exist. This seemed easy to do since I could run …

Tags: , , , , , , , , | Posted under Programming/Coding | Comments Off

Populate SQL Table with All Valid Dates Between Two Periods

I am working on a request from a client that required the use of a date table, but not just any date table. This table had some additional requirements; 1. …

Tags: , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment