Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

where to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime table Expand / Collapse
Author
Message
Posted Monday, December 10, 2012 4:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 12, 2013 9:58 AM
Points: 39, Visits: 230
Hi 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!!
Post #1394804
Posted Monday, December 10, 2012 4:23 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:27 PM
Points: 33,204, Visits: 15,351
I assume you mean something like this: http://www.sqlservercentral.com/articles/T-SQL/70482/

You'll have to customize the code based on what values/resolutions you need in your table.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1394812
Posted Monday, December 10, 2012 5:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 12, 2013 9:58 AM
Points: 39, Visits: 230
Thanks Steve!!
Post #1394823
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse