blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

Browse by Tags

All Tags » SQL » Date functions » case statement
  • T-SQL: Common date ranges; Daily, Weekly, Monthly, Yearly, Last 12 Months

    As promised in my original post on PL/SQL date ranges previously, below is a sql statement which can be used preceeding most queries in order to apply common date range lookups to the data the query returns. SQL Server Management Studio (SSMS) doesn't have an equivalent to the '&' functionality that TOAD has to ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on March 1, 2007
  • Selecting the last weekday in a given month

    In one of my frequent trips through Google on the search for how to do something (I forget what it was I was looking for on this particular occasion), I found myself, as I often do, being directing to various contributions from posts on life after coffee.com Whilst the entry it turned out wasn't relevant to what I was searching for, it did ...
    Posted to Jim 2.0 (Weblog) by James.Pipe on February 3, 2007
Powered by Community Server (Personal Edition), by Telligent Systems