Tag Archives: sql

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 | Leave a comment

LINQ to SQL with Totals

Ever since I have been using Linq2SQL, I am always impressed by the speed and the functionality of it. However; using SQL for 10+ years I always find my self …

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

Convert SQL to LINQ Tool

If you are like me and have worked for years building somewhat complex queries using t-SQL but are also trying to learn and use LINQ2SQL then you know that it …

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