where to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » where to find the {script/stored procedure}...

where to find the {script/stored procedure} in SQL SERVER DATAWAREHOUSE which populated DimTime table

Rate Topic

Display Mode

Topic Options

Author

Message

tinnusqlserver

Posted Monday, December 10, 2012 4:02 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 4:07 PM
Points: 38, Visits: 227

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

Steve Jones - SSC Editor

Posted Monday, December 10, 2012 4:23 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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

tinnusqlserver

Posted Monday, December 10, 2012 5:07 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 4:07 PM
Points: 38, Visits: 227

Thanks Steve!!

Post #1394823

« Prev Topic | Next Topic »

Permissions