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 ve.Branch,count(ve.ID) 'No of Available Employees ' from [220.127.116.11].HumanResources.dbo.vwEmployee ve left join [18.104.22.168].HumanResources.dbo.vwBranch vb on ve.branch=vb.Name where ve.leavingdate is null group by ve.branch order by ve.Branch Select D.Branch,D.Employees 'No of Registered Employees' from (select A.Branch,count(A.EmployeeID)'Employees' from (select E.EmployeeID,E.Firstname,E.Lastname,B.Branch from dbo.tblEmployee E left join dbo.tblBranch B on E.BranchID=B.BranchID left join [22.214.171.124].HumanResources.dbo.vwEmployee VE on E.EmployeeID =VE.ID where VE.LeavingDate is null )A group by A.Branch )D order by D.Branch
|Addition to SQL for dynamic fields||6||37|
|Please help with the below query - SQL Server||11||17|
|For duplicated records, how to update a certain field of all duplicated records (to match one record among these duplicated records)||7||20|
|How To Convert Date Stored as Varchar as an MSSQL DATE Type Field In a VIEW||3||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!