"UNOIN" is interpreted by the SQL Query Process as an alias. This interpretation as an alias creates problems when writing SQL that will need to run versus different RDBMS. For example, this ISO standard SQL will run successfully versus Sybase & SQL...

Regarding "Can a shift extend to the next day? " Yes a shift can start on monday and end on tuesday. In such a case, the end time will be smaller than or equal to start time. For example 10:00-08:00 indicates that the shift starts at 10 AM and ends at 08:

Radu Negru posted a question about the sort order and your response was "The employees should be ordered by lastname, firstname". Does not this rule also need to include the additional qualification "within the employee's manager" ? Also, if two employ

Here are some assumptions on table constraints:: For table @emp 1. Columns EmployeeID , FirstName and LastName are all "NOT NULL". Note that column ReportsTo may be null as shown in the test data. 2. Columns FirstName and LastName have a datalength gr