Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... is incorrect in Zoho Analytics, and payroll gets run with these discrepancies, then they will have a fair few disgruntled employees who may have been paid incorrectly. As such this system has to be reliable ...; Created on 02 July 2024
2. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an employee for applying for leave if over 80% of the department ...; Created on 10 December 2020
3. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... sold by JoelLipman.com. JoelLipman.com agents, representatives and employees are to be held harmless from any and all claims, liabilities, damages, and expenses (including attorneys’ fees actually incurred) ...; Created on 24 October 2014
4. Convert to Proper Case in T-SQL: / Transact-SQL /; ... Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in ...; Created on 04 June 2014
5. T-SQL: Parse an XML value: / Transact-SQL /; ... Looping -- From resultset of $i ,assigning it to variable $j using let clause, -- Getting top two employees by using where & order by clause. SELECT Event_XML.query('for $i in /STAFF/student let ...; Created on 27 March 2014
6. Split a row into multiple rows based on a column value: / Transact-SQL /; ... has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per ...; Created on 23 August 2013
7. T-SQL concatenate an incremental row number: / Transact-SQL /; ... which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the ROW_NUMBER() statement: SELECT ...; Created on 24 May 2013
8. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... @EmployeeStr = 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM ...; Created on 14 May 2013
9. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ...; Created on 27 April 2012
10. Passwords: Did-you-know: / IT Support /; ... network simply drops loads of free nice USB flash drives in the parking lot. Employees pick them up and plug them into their machines at work which then sends the details over the internet. Apparently ...; Created on 15 November 2010