Geeks With Blogs
Graeme Reisinger Welcome to my Office. My Other Office. SQL Server SQL Server Tips n' Tricks
SQL Server Dynamic Where Clause Column Names
Let me start this post by saying if you are searching for the capability to do this, there is a very good chance you have problems with your current database architecture. Having said that, I realize you may not have the option of normalizing your database, and have no choice but to work with what you've got. If this is the case, you may find the following post a useful workaround to whatever problem is causing you to search for a dynamic WHERE clause. A dynamic WHERE clause might be useful if you ......

Posted On Wednesday, December 29, 2010 7:40 PM

Business Logic: Should it exist in the code or in the database?

If your team is in this quandry, read on...

Posted On Sunday, June 27, 2010 12:56 PM

SQL Server Dynamic SQL - A Comprehensive Example
With Dynamic SQL, one stored proc can do the work of many... Over the years, I have worked with a variety of different clients. It seems that every client has unique and different needs. In some situations, you may find that dynamic sql fills the void better than other solutions available to you. One scenario I have encountered in the past is one where the client wants the capability to run aggregate information at run time, but for any start month and number of time periods. There are many ways ......

Posted On Tuesday, June 15, 2010 9:32 PM

SQL Server Date Comparison Functions

When you need the earlier of or later of two dates and NULL handling capability.

Posted On Sunday, June 13, 2010 1:56 PM

SQL Server Split() Function

Add flexibility to your database with parsing functions.

Posted On Sunday, June 6, 2010 8:33 PM

High-Powered Sites for low Cost

Excellent learning for the job-seeker.

Posted On Sunday, May 23, 2010 11:45 PM

Copyright © HighAltitudeCoder | Powered by: