SQL Server 2005: CTEs - Getting to the Bottom of the Hierarchy
You can think of a recursive CTE (R-CTE) as a recursive query. Without CTEs, going through a hierarchy can be painful, often requiring temporary tables, and knowledge of the maximum depth of the hierarchy. R-CTEs can traverse a hierarchy very easily. We are going to use an R-CTE to traverse a hierarchy.
Inexpensive Ways to Keep Your Best Employees
A common issue for employers these days is keeping good employees. The U.S. Department of Labor estimates that the cost of replacing an employee to be one-third to one-half of that employee's pay and benefits. The Society for Human Resource Management (SHRM) estimates that it costs $3,500 to replace one $8.00 per hour employee when all costs - recruiting, interviewing, hiring, training, reduced productivity, etc. - were considered.
SQL Server 2005: Common Table Expressions (CTEs)
Common Table Expressions (CTEs) are new to SQL Server 2005. CTEs are defined in the ANSI SQL-99 standard. We need to begin learning about the new features of SQL 2005 and CTEs are an interesting place to start. You will learn about the syntax and how to think about CTEs.
Compliance and Sexual Harassment Prevention Training
As we all know, sexual harassment is a form of sex discrimination that violates Title VII of the Civil Rights Act of 1964. It also costs U.S. businesses millions of dollars each and every year.