May 20, 2017 at 4:49 pm
Comments posted to this topic are about the item Listening and Taking Action
May 22, 2017 at 6:21 am
I wonder, that the only connect item I found for a column based MIN/MAX (similar to Oracle's LEAST()/GREATEST()) got only 4 quotes since last year (https://connect.microsoft.com/SQLServer/Feedback/Details/3085573).
Maybe someone who reads this will vote too 🙂
PS:SELECT LEAST(a, b, c, d, e) AS MinID
FROM (VALUES (7, 3, 5, 1, 9)) t(a, b, c, d, e)
should return 1.
Today you have to code something like thisSELECT (SELECT MIN(d) FROM (VALUES (t.a), (t.b), (t.c), (t.d), (t.e)) AS tmp(d)) AS MinID
FROM (VALUES (7, 3, 5, 1, 9)) AS t(a, b, c, d, e)
God is real, unless declared integer.
May 22, 2017 at 11:08 am
Part of the issue is search on Connect is a mess. I'll look, not find my issue, file it, and then get told there's a duplicate later, which I couldn't find.
May 22, 2017 at 12:21 pm
My favorite MS Connect item is https://connect.microsoft.com/SQLServer/Feedback/Details/258733. It's still active, in spite of having its 10th birthday party on 2/18 of this year.
I get that MS looks at the product a whole lot differently than we do, but I don't think it wouldn't kill them to listen to the people who use it. I mean listen the way you describe it in the editorial, Steve. Nice one, by the way.
May 22, 2017 at 12:22 pm
Steve Jones - SSC Editor - Monday, May 22, 2017 11:08 AMPart of the issue is search on Connect is a mess. I'll look, not find my issue, file it, and then get told there's a duplicate later, which I couldn't find.
Agreed. Personally, I search using Bing and preface my search phrase with ms connect. It usually does pretty well.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply