Viewing 15 posts - 661 through 675 (of 1,837 total)
November 14, 2017 at 12:39 pm
November 13, 2017 at 4:41 pm
OK, here's a couple of questions for you to think about:
1. Can you have an Equipment row without an Order?
2. How many Order rows can an Equipment row...
November 13, 2017 at 3:12 pm
If all you want to do is allow users to see execution plan, it's probably preferable to just do a GRANT SHOWPLAN:
https://technet.microsoft.com/en-us/library/ms189602(v=sql.105).aspx
DB_Owner would probably be overkill...
November 13, 2017 at 2:54 pm
November 13, 2017 at 11:05 am
Phil Parkin - Monday, November 13, 2017 7:33 AMSummed up by George Bernard Shaw as: "Remember: those who can, do; those who can't, teach."
I think the parallel to that...
November 13, 2017 at 10:57 am
Maybe the ROLLUP operator could help?
https://technet.microsoft.com/en-us/library/ms189305(v=sql.90).aspx
You would have to change your GROUP BY to include the additional columns that you want to aggregate at the lower...
November 13, 2017 at 10:41 am
November 13, 2017 at 10:21 am
November 10, 2017 at 1:10 pm
November 10, 2017 at 12:21 pm
hey... 60% of the...
November 9, 2017 at 11:34 am
Using datetime in the DOB column makes it a bit more confusing, but it looks like you're considering any point in the day as the whole day? If so and...
November 9, 2017 at 10:02 am
November 9, 2017 at 8:50 am
I suppose it depends on their current knowledge base. At a very beginning level I'd start with set theory:
https://www.mathsisfun.com/sets/venn-diagrams.html
If they don't understand sets properly, then anything...
November 9, 2017 at 8:34 am
Viewing 15 posts - 661 through 675 (of 1,837 total)