Tag Archives: sql

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

SQL Server NULLIF Function

If you are like me when it comes to developing SQL solutions, you will inevitably use ISNULL function but did you know about NULLIF function. This function is almost the opposite …

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

Calculating Percent of Total in a SQL Select Statement

I am always amazed at how SQL server provides a lot of calculations and logic built right into a select statement. Most of the time (if you are like me) …

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