InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 03:16:41 GMT20http://www.sqlservercentral.com/Forums/Topic1416461-3077-1.aspxdont cross post, it fragments replies and wastes peoples timeall replies here [url]http://www.sqlservercentral.com/Forums/Topic1416459-1292-1.aspx[/url]Wed, 06 Feb 2013 06:35:16 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1416461-3077-1.aspxGood MorningI am new to T-Sql and I have been taske with creating a simple Time table with four columns:Date date not null,CalendarYear int not null,CalendarMonth varchar (30) not null,FinancialYear int not null,FinancialMonth varchar (30) not null)And what I would like to do is populate the Date column with dates from 01/01/2011 upto 31/03/2015 and the other columns will self populate:Example:Date CalendarYear CalendarMonth FinancialYear FinancialMonth01 Jan 2011 2011 January 2010 January02 Jan 2011 2011 January 2010 January03 Jan 2011 2011 January 2010 January04 Jan 2011 2011 January 2010 January05 Jan 2011 2011 January 2010 JanuaryCan you help?ThanksWayne Wed, 06 Feb 2013 06:14:57 GMTwafw1971