617 Nov 2006 @ 10:04 PSTDatabaseReplySQL QuestionI should have been more explicit. Let's assume that I do not have the actual date column in my table and that I just have a month column and a year column.
516 Nov 2006 @ 03:56 PSTDatabaseTopicSQL QuestionIs the following the best way to eliminate the days of October 2006 from the result?select *from sys_calendar.calendarwhere (month_of_year in(1,2,3,4,5,6,7,8,9,11,12)) or (month_of_year = 10 and ...
410 Oct 2006 @ 08:30 PDTToolsTopicCalculate the number of months between two datesDoes anyone know the best way to do this?
326 Jun 2006 @ 04:24 PDTToolsTopicSQL MedianDoes anyone know how to calculate the median using SQL?
227 Apr 2006 @ 10:20 PDTToolsReplyPivot a table with SQLIt seems if I need to know the number of columns that I will need in these solutions. I would potentially need 100 columns convert from rows. Do you have any other thoughts?
112 Apr 2005 @ 03:42 PDTToolsTopicPivot a table with SQLDoes anyone have a good way to pivot a table when there is a variable amount of columns? I know that it can be done with a CASE statement, but that is tedious.