Tuesday, January 28, 2014

Split date range without Calendar table

Instead of having the datetime datatype, why don't you try a datekey and timekey as Integers and use that to join to the table you wanted like we do in the fact tables of data warehouses.??

No comments:

Post a Comment