Viewing 15 posts - 1,501 through 1,515 (of 3,047 total)
Thanks for the script.
March 29, 2016 at 7:07 am
Steve Jones - SSC Editor (3/28/2016)
yes, sorry. Typo corrected. That's what I get for trying to type code in here instead of copy/paste.
Copy/paste can be just as dangerous. I've seen...
March 29, 2016 at 7:05 am
Jamsheer (3/29/2016)
Missed the "Distinct" 😛
Yep, that'll get ya.
March 29, 2016 at 7:03 am
Good subject today. I agree on the input errors and especially coding for them. Limit input to what is acceptable and allow for easier cleanup when even that is entered...
March 28, 2016 at 7:01 am
Steve Jones - SSC Editor (3/25/2016)
DBA_Rob (3/25/2016)
March 28, 2016 at 6:56 am
Good article, thanks.
March 28, 2016 at 6:53 am
sknox (3/25/2016)
The MIN() and MAX() functions are aggregates, therefore the NULL is eliminated.
is not true.
The reason the NULL is...
March 28, 2016 at 6:52 am
Interesting question. The wrong answers were obvious. But the right answer I had to think about. I've never constructed a query like that before, using distinct in the HAVING clause's...
March 24, 2016 at 7:01 am
Viewing 15 posts - 1,501 through 1,515 (of 3,047 total)