Viewing 5 posts - 1 through 6 (of 6 total)
When i use these two dates
DECLARE @startDateTime DATETIME = '2016-01-01 00:00:00';
DECLARE @endDateTime DATETIME = '2016-01-30 23:59:59';
I get these result
PayRateNamepaymonth_yearEmp_IDPayUnits ...
February 8, 2016 at 4:17 pm
Well this is the current solution i could come up with do you want to suggest a better solution?
February 8, 2016 at 3:05 pm
I get this error
The CUBE() and ROLLUP() grouping constructs are not allowed in the current compatibility mode. They are only allowed in 100 mode or higher.
February 8, 2016 at 3:03 pm
I just tried the SQL Fiddle now, and its working. Maybe the server was down when you accessed it
February 8, 2016 at 1:01 pm
Hello
Fot Jude who os am SC (Salary plus commission) employee, he gets his montly salary plus 5% of the total sales
Pay = employee.Payrate + (total sales * (employee.Commission/100))
see...
February 8, 2016 at 9:19 am
Viewing 5 posts - 1 through 6 (of 6 total)