Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Error I get for the following query:
- Column "dbo.T_BRANCH_PRODUCTIVITY.F_HOURS_DATE" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
- SELECT COUNT(*) as count FROM [dbo].[T_BRANCH_PRODUCTIVITY] WHERE F_BRANCH = 0 AND F_HOURS_DATE >= '2016-11-07' AND F_HOURS_DATE <= '2016-11-13' ORDER BY F_HOURS_DATE ASC
Advertisement
Add Comment
Please, Sign In to add comment
