John Petrak questions

John Petrak answers

• select dept names who have more than 2 employees whose salary is greater than 1000
• Order by descending date - month, day and year
• System.UnauthorizedAccessException: Access to the path is denied VS2013
• How to use result of an subquery multiple times into an query
• adding User control / Page to windows xaml programmatically in WPF
• Do mysql update queries benefit from an index?
• WCF change endpoint address at runtime
• Mysql -- Use a secondary subquery if and only if the first subquery returned empty
• MVVM separation of Data Access from ViewModel