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 |
|
jay83091
Starting Member
14 Posts |
 Posted - 2010-10-06 : 19:28:54
|
| Hi Experts,I am using SQL 2005 and trying to create bunch of flags in my time dimension table.1. Previous Day Flag2. Current Day Flag3. MTD Flag (i.e. Beginning of the month till current day)4. YTD Flag (i.e. Beginning of the year till current day)What would be the best way to create these flag in dim_time?Any help would be appreciated.Thank youJames |
|
|
kunal.mehta
Yak Posting Veteran
83 Posts |
Posted - 2010-10-07 : 02:46:24
|
| can u provide the table structure and elaborate about your requirement a little bit |
 |
|
|
|
|
|
Creating a flag in Time dimension table