Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
SELECT EmployeeNum_1.EmployeeID, EmployeeNum_1.TempId, EmployeeNum_1.Unldr_#, EmployeeNum_1.Last_name, EmployeeNum_1.First_name, EmployeeNum_1.Active, EmployeeNum_1.PayRateHourly, EmployeeNum_1.PayRatePercentage, EmployeeNum_1.SpecialPay, EmployeeNum_1.HolidayPay, EmployeeNum_1.SalaryPay, WorkDays_1.Workdate, WorkdayPunches_1.Punchkey AS PunchKey, WorkdayPunches_1.PunchTime, WorkdayPunches_1.Action, WorkdayPunches_1.Note, WorkdayPunches_1.Deleted AS PunchDelete, WorkDays_1.deleted AS WorkDayDelete, EmployeeNum_1.JobTitle FROM EmployeeNum AS EmployeeNum_1 INNER JOIN WorkDays AS WorkDays_1 ON EmployeeNum_1.Unldr_# = WorkDays_1.Unldr_# INNER JOIN WorkdayPunches AS WorkdayPunches_1 ON WorkDays_1.UID = WorkdayPunches_1.Punchkey WHERE (EmployeeNum_1.Active = 1) AND (DATEPART(wk, WorkdayPunches_1.PunchTime) = DATEPART(wk, @Date)) ORDER BY WorkDays_1.Workdate, WorkdayPunches_1.PunchTime
|display dynamic list as a 'Text' from Oracle script to Crystal reports||16||63|
|SSRS 2008 r2 - finding the selection Screen||3||123|
|Crystal reports subreports as total of main report||13||69|
|Create formula that divides total amount by 30 or 31 depending on what month of the year it is looking at||5||38|