blogs.conchango.com

Browse by Tags

• Analytic functions
• case statement
• Date
• Date functions
• Date range
• join
• last_day
• MTD
• next_day
• Oracle
• order by
• partition by
• PL/SQL
• Previous row
• self join
• SQL Server
• TOAD
• T-SQL
• YTD

• SQL tutorials and learning resources

  Following a few requests, here are some sites you may find useful for supporting your SQL learning: General http://www.stickyminds.com/ http://www.thefreecountry.com/documentation/onlinesql.shtml (free online tutorials) T-SQL http://sqlcourse.com/ (free Read More... Posted 14 November 2007 16:26 by James.Pipe | 0 Comments Filed under: PL/SQL, PL-SQL, SQL, T-SQL, SQL Server

• PL/SQL Calendar table

  In addition to the T-SQL calendar table , which I have posted seperately, I went the whole hog and figured out the equivalent for Oracle. The only value I couldn't work out was the millisecond, which is not present on the standard date type in Oracle, Read More... Posted 24 April 2007 16:00 by James.Pipe | 4 Comments Filed under: PL/SQL, PL-SQL, SQL, Date functions, Date, Date range

• PL-SQL: Common date range lookups; Daily, Weekly; MTD; YTD; Last 12 Months

  As part of my current role as a tester I am often required to write the same basic expressions again and again in my queries, most noticeably to bring back data for specific date ranges, therefore for the benefit of anyone else out there who has to do Read More... Posted 10 February 2007 04:00 by James.Pipe | 11 Comments Filed under: Oracle, PL-SQL, SQL, next_day, last_day, Date functions, Date, Date range, MTD, YTD

• PL SQL: Passing variables in TOAD for Oracle

  I regularly need to pass variables into my queries, and when running multiple tests, it helps to have a way to change these variables easily, preferably, without having to go through the query each time and change the sql. Fortunately for me TOAD (Tool Read More... Posted 10 February 2007 03:30 by James.Pipe | 2 Comments Filed under: Oracle, PL-SQL, SQL, Date, TOAD

• 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 Read More... Posted 03 February 2007 20:33 by James.Pipe | 1 Comments Filed under: Oracle, PL-SQL, SQL, case statement, next_day, last_day, Date functions

• An update on Analytic Functions for T-SQL

  Hi, following on from my previous two posts about Analytic Functions , and specifically about the lack of a T-SQL equivalent to the LAG and LEAD functions I demonstrated, there is a SQL Server feedback vote currently active which you can participate in Read More... Posted 30 January 2007 03:42 by James.Pipe | 1 Comments Filed under: Oracle, PL-SQL, SQL, Analytic functions, Previous row, T-SQL

• PL-SQL: Returning a value from the previous row in a query

  For any number of reasons which I won’t go into, you may have a need, or desire, to return a value in a query from one row next to a value from another. A typical example might be in a daily sales database, where I want to see yesterday’s Read More... Posted 24 January 2007 20:33 by James.Pipe | 5 Comments Filed under: Oracle, self join, PL-SQL, join, SQL, Analytic functions, order by, Previous row, partition by