Viewing 8 posts - 1 through 8 (of 8 total)
Hmm, interesting. I was using ‘bog standard’ excel accessing the database, will have to try/investigate power pivot. I have users trying to reconcile figures using management studio, but the grouping...
August 20, 2021 at 9:00 pm
The question said "every employee", that should be clear enough, one record per employee. If you DISTINCT, you get list of peoples names, not people.
"There's Brian over there, and that's...
November 12, 2014 at 2:38 am
I was somewhat gobsmacked when I saw the percentage of people that got this wrong.
Then I read this thread.
September 17, 2014 at 3:12 am
I got confused by "suppotys"
May 8, 2014 at 4:29 am
No problem 😎
It's funny, mind: I did think that making it Char(32) I was giving it away, but the right answer was by no means getting 90% of respondents getting...
February 11, 2014 at 8:34 am
Is it OK if I copy and paste one of the code sections from higher up?
(Whoa!!! OK, not really going to!)
,ROW_NUMBER() OVER (ORDER BY ID_key, Party_No) -
December 5, 2013 at 2:36 am
Four Points! Yay!
I understood this question not at all. but I figured the correct answer had to be number two of five, the one above "this can never happen" which...
August 23, 2013 at 2:06 am
I guess what I'm not getting my head around is, what exactly is that subquery returning?
(select col1 from TblA2 where TblA1.col2 = TblA2.col2)
Is it returning TblA1.col1? If so that's reeeeeeally...
January 17, 2013 at 5:29 am