Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
SELECT ServiceTech1, ServiceTech2, ServiceTech3 FROM (SELECT A.EmpName AS ServiceTech, ROW_NUMBER() OVER (ORDER BY EmpName) seqNum, CASE WHEN ROW_NUMBER() OVER (ORDER BY EmpName) = 1 THEN EmpName END AS ServiceTech1, CASE WHEN ROW_NUMBER() OVER (ORDER BY EmpName) = 2 THEN EmpName END AS ServiceTech2, CASE WHEN ROW_NUMBER() OVER (ORDER BY EmpName) = 3 THEN EmpName END AS ServiceTech3 FROM tblUsers A, tblJobs B, tblJobLookup C WHERE A.ID = C.EmployeeID AND C.JobID = B.JobID AND B.JobNumber = 'JobNumber') MC
|How would you modify the following SQL Server 2008 stored procedure to prevent it's execution if the value being inserted into the field "BRANCH" is a duplicate ? Branch is the Primary Key.||2||19|
|fault SQL backup files that wont restore - how common||3||26|
|Are triggers slow?||7||13|
|How to execute a SQL Server Stored Procedure from an Access front-end?||15||37|