Tag Archives: period

Finding Week Number in SQL Based on Fiscal Period

If your fiscal year matches the calendar year then SQL has an easy process of find the week number. You simply use something like this:

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

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