June 2010 Entries
If your team is in this quandry, read on...
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...
When you need the earlier of or later of two dates and NULL handling capability.
Add flexibility to your database with parsing functions.