Geeks With Blogs

News Locations of visitors to this page

Graeme Reisinger Welcome to my Office. My Other Office. June 2010 Entries
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

Copyright © HighAltitudeCoder | Powered by: