Welcome to EMC Consulting Blogs Sign in | Join | Help

Browse by Tags

All Tags » t-sql » List of dates
  • PL/SQL and T-SQL for Week Ending Date

    Recently my colleague challenged me to  find a method for identifying the week ending date for the week which any given date belongs to; i.e. say for a gven date which happens to be a Tuesday, what is the date of the end of the week? In this example, week ending is defined as a Sunday, however depending on how your server is set up, ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on April 24, 2007
  • T-SQL: Generate a list of dates

    Sometimes we can be working and we write or find a ridiculously simple bit of code that we know will be useful in the future, then we just go ahead and plain forget all about it. When I find such stuff I like to stick it on my blog so that I know where to find it in the future and also on the off chance that someone else might ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on January 11, 2007
Powered by Community Server (Personal Edition), by Telligent Systems