datetime Script - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

datetime Script

Author

Topic

rajan_kr
Starting Member

9 Posts

Posted - 2008-07-18 : 12:31:34

Hi All,

Please help me in this.
I have a table [dbo].[FISCAL_QTR]
([FISCAL_QTR_ID]
,[FISCAL_QTR]
,[FISCAL_YEAR]
,[DESCR]
,[START_DATE]
,[END_DATE])
and the data's in this table is like this
41,1,2010,2-2010,11/2/2009 12:00:00 AM,1/31/2010 12:00:00 AM
42,2,2010,2-2010,2/1/2010 12:00:00 AM,5/2/2010 12:00:00 AM
43,3,2010,3-2010,5/3/2010 12:00:00 AM,8/1/2010 12:00:00 AM
44,4,2010,4-2010,8/2/2010 12:00:00 AM,10/31/2010 12:00:00 AM

now i have to expand the table till 2015, with the same format.
Can anyone help me in writing a script for the same.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-18 : 12:35:05

Don't cross post

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

rajan_kr
Starting Member

9 Posts

Posted - 2008-07-18 : 12:38:05

is anyone who can help me

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources