SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / where to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:19:12 GMT20RE: where to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime tablehttp://www.sqlservercentral.com/Forums/Topic1394804-391-1.aspxThanks Steve!!Mon, 10 Dec 2012 17:07:57 GMTtinnusqlserverRE: where to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime tablehttp://www.sqlservercentral.com/Forums/Topic1394804-391-1.aspxI assume you mean something like this: [url]http://www.sqlservercentral.com/articles/T-SQL/70482/[/url]You'll have to customize the code based on what values/resolutions you need in your table.Mon, 10 Dec 2012 16:23:17 GMTSteve Jones - SSC Editorwhere to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime tablehttp://www.sqlservercentral.com/Forums/Topic1394804-391-1.aspxHi Friends,I need your suggestion.We have a SQL SERVER 2008R2 dataware house. In this we have a table "DimTime". This DimTime table contains only data/records until 2013. NOW, we have to populate 2014 data/records also into DimTime table.My manager told me to find/search the StoredProcedure/script inside the prod SQL SERVER 2008R2 dataware house which they used earlier to populate data into DimTime. I had checked all the stored procedures/scripts but i couldn't find it.Question: Is it possible to populate DimTime other than storedprocs/scripts ?? Am I doing this correctly ??Thanks for your time!!Mon, 10 Dec 2012 16:02:38 GMTtinnusqlserver