Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Function to get number of days in month

    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'

  • RE: Function to get number of days in month

    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...

  • RE: Essential Software

    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...

  • RE: 4-4-5 Calendar Functions, Part 1

    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....

  • RE: The Worst Advice

    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...

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    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,...

  • RE: Change column order in Flat File Destination

    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...

Viewing 7 posts - 1 through 7 (of 7 total)