#DateWhereItemComment
523 May 2011 @ 03:48 PDTÜber SQLMissing Functions: DENSE_RANKNice work Dieter. Very informative.
419 Apr 2011 @ 09:23 PDTRobG's blogDetermining Month-End Date for a Date Dimensionbmcclernan, that's a great tool to have available. Here's a quick test showing the three calculations in this post: SELECT calendar_date, ADD_MONTHS(calendar_date - day_of_year, mon...
304 Mar 2011 @ 04:27 PSTRobG's blogDetermining Month-End Date for a Date DimensionNice. Your logic produces the exact same result as mine. I was populating the date dimension in our warehouse using Teradata's sys_calendar.CALENDAR table as a source. That's why I used those sp...
214 Feb 2011 @ 03:45 PSTRobG's blogDetecting a Broken Prior Value/New Value ChainDieter, those are great suggestions. Thank you!
114 Feb 2011 @ 10:11 PSTRobG's blogUsing INTERVAL to Add or Subtract Fractional Seconds to or from TIMESTAMP Valuescrowley, thanks for the explanation (speculation?). Makes sense to me.