Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2013-04-24 : 11:45:08
|
| HeyDoes anyone know how to create a yesterday flag in a date dimension as oppose to the standard year, month, week, day flags? also be good to see hour, half hour, min, ...is it worth creating 2 dimension here one one date and one time?ThanksSZ1Learning and development is the driving force in the universe...! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-24 : 12:59:09
|
| if you want to store hour, halfhour etc better to have separate time dimension. ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-04-30 : 04:47:52
|
| ok so have a Date Dim and a seperate Time DimThanksSZ1Learning and development is the driving force in the universe...! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-30 : 04:54:31
|
| yep...that will do------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Time Dimension