Post reply

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

  • December 10, 2012 at 4:02 pm

    #271815

    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!!

  • December 10, 2012 at 4:23 pm

    #1567200

    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.

  • December 10, 2012 at 5:07 pm

    #1567210

    Thanks Steve!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply