Viewing 15 posts - 3,571 through 3,585 (of 7,609 total)
But if only the start date is in the row, how do you handle "changes in interval"? And especially a variable interval, say, where some rows apply for 2 weeks...
January 26, 2018 at 8:31 am
You seem fixed to the idea that "every view must be schema bound." That's...
January 25, 2018 at 10:09 am
You seem fixed to the idea that "every view must be schema bound." That's just not true, and probably not even optimal.
January 25, 2018 at 8:52 am
January 25, 2018 at 8:48 am
I simply offered an alternative: rather than searching for errors yourself, let SQL find them for using sp_refreshview. Probably on your qa/test system, as the views are likely identical or...
January 25, 2018 at 8:04 am
January 25, 2018 at 7:25 am
Say we have your table with only beginning dates. Now I want to join to...
January 25, 2018 at 7:01 am
January 25, 2018 at 6:56 am
Sometimes when joining, it's easier if the ending value is in the row itself. It's...
January 24, 2018 at 3:51 pm
January 24, 2018 at 12:46 pm
Viewing 15 posts - 3,571 through 3,585 (of 7,609 total)