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