Viewing 15 posts - 16 through 30 (of 204 total)
drew.allen (9/8/2016)
Also, my approach can easily be used with derived tables, again being consistent. You're approach could quickly become cumbersome with derived tables.Drew
How?
September 8, 2016 at 10:07 am
Phil Parkin (9/8/2016)
September 8, 2016 at 6:59 am
Phil Parkin (9/8/2016)
I disagree. It makes perfect sense. He *always puts ON clauses on separate indented lines* – perfectly consistent.
That's the point I'm making - it's consistent, but no more...
September 8, 2016 at 5:50 am
drew.allen (9/7/2016)
September 8, 2016 at 5:15 am
djackson 22568 (2/19/2016)
... Our society has a huge issue with thinking that we have a right to not be offended. The way to handle that is the delete button.
OMG,...
February 19, 2016 at 9:32 am
I don't think we'll get very far by trying to demonstrate things "how they should be", particularly if we could be following accepted behaviour ourselves.
Rather, I feel it's better...
February 19, 2016 at 9:00 am
richlion2 (2/19/2016)
February 19, 2016 at 6:41 am
Just do what you're doing Andy, you're doing a great job.
February 19, 2016 at 3:26 am
Eric M Russell (10/23/2015)
contextual based on a range comparison.
-- return all currently active customers:
select * from...
October 23, 2015 at 9:08 am
angel-626714 (10/23/2015)
david.wright-948385 (10/23/2015)
October 23, 2015 at 9:04 am
RonKyle (10/23/2015)
That's perfectly fine. It relates to the individual record. Where's the denormalization in that?
You have two indicators for the same thing: the flag, and whether the date...
October 23, 2015 at 8:15 am
Eric M Russell (10/23/2015)
October 23, 2015 at 7:11 am
angel-626714 (10/23/2015)
I would also have a column for the date and time it became inactive.
Denormalisation alert 🙂
October 23, 2015 at 7:02 am
Henk Schreij (10/23/2015)
VARCHAR(1), Default '' (an empty string).
I fill this field with a Char...
October 23, 2015 at 4:35 am
Viewing 15 posts - 16 through 30 (of 204 total)