Viewing 7 posts - 1 through 7 (of 7 total)
ramanamreddy (5/2/2011)
how to give any mnth to the above query?
Apologies for the late reply:
SELECT DISTINCT d.DaysInCalendarMonth
FROM dbo.dwCalendars d
WHERE d.CalendarYear = 2011
AND d.CalendarMonthName = 'February'
June 13, 2011 at 12:21 pm
Of course, if you use a calendars table you never have to worry about having to code or validate any date calculations ever again. 😛 Sure makes life a...
April 27, 2011 at 3:29 pm
I find Multi-Edit very useful because you can copy/paste/delete columns as opposed to just rows. I'm sure there are other tools that do this as well. I find...
April 9, 2010 at 7:57 am
Great article, Cliff!
I would recommend building a date dimension table for this kind of thing. Add columns for everything you might want to know about each date....
September 28, 2009 at 5:04 pm
Bad Advice
Yes, I agree that most of the time people have good intentions and don't intentionally give bad advice. It harkens back to a favorite quote of mine -
"It's...
July 10, 2009 at 10:23 am
Nicely written article, Jeff! I'm new to this forum so don't know if you've covered it already, but it might be nice to see a counterpart to this article,...
August 19, 2008 at 10:02 am
Here is what worked for me -
* Delete the Flat File Destination and the Flat File Connection Manager.
* Create a file with the column headings you want in the order...
August 7, 2008 at 6:14 pm
Viewing 7 posts - 1 through 7 (of 7 total)