Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Print Text Month Calendar

By Bernabe Diaz, 2012/11/29

Test it as follows:

print [dbo].[myCalendar] (getdate())+ CHAR(13)

print [dbo].[myCalendar] (dateadd(month,+1,getdate()))+ CHAR(13)

print [dbo].[myCalendar] (dateadd(month,+2,getdate()))+ CHAR(13)

print [dbo].[myCalendar] (dateadd(month,+3,getdate()))+ CHAR(13)

Total article views: 1442 | Views in the last 30 days: 27

Related Articles

FORUM

dateAdd inside where clause

dateAdd function syntax help

ARTICLE

Date Manipulation with DATEADD/DATEDIFF

Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phel...

BLOG

DATEADD and variables in SQL

To make the T-SQL function DATEADD more dynamic use variables. The example below , accepts an input...

FORUM

Print Text Month Calendar

Comments posted to this topic are about the item [B]Print Text Month Calendar[/B] Hi Bernabe, Nice...

FORUM

DateAdd

Trying build this some that it will return 24 months from the current day. What am I doing wrong?? ...

Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Steve Jones