Print The Calender

• Vinay Kumar

  SSCertifiable

  Points: 6099

  More actions

  January 30, 2008 at 3:23 pm

  #178740

  Comments posted to this topic are about the item Print The Calender

  Thanks
  Vinay Kumar
  -----------------------------------------------------------------
  Keep Learning - Keep Growing !!!

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 30, 2008 at 3:47 pm

  #773559

  The link below has a number of different examples. My own is, of course, the very best.:P

  Creating a Formatted Calendar

  There are several methods is this link that will return a result set with a formatted calendar.

  Calender In Sql Server:

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44865

• darren.sunderland

  Mr or Mrs. 500

  Points: 531

  More actions

  March 5, 2008 at 10:45 am

  #785648

  I just uploaded my own calendar script which uses the system tables to display the day and month names in the language chosen by the user.

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  March 5, 2008 at 11:04 am

  #785657

  Ok... it's a fun exercise, but I've gotta know... why did you folks decide to do one in SQL? I mean, what do you actually use it for? Not trying to be a wise guy here... I don't understand the utility in this and thought I'd ask.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)