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.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
DECLARE @fromdt AS datetime DECLARE @todt AS datetime SET @fromdt = '7/1/2014' SET @todt = '7/31/2014' select * from tblOrgRegistrations as r JOIN tblOrgHours as h ON h.RegID = r.regid Where r.AgencyID = 74 And (h.ActivityDate >= @fromdt And h.ActivityDate <= @todt) Group By r.Agency
Msg 8120, Level 16, State 1, Line 5 Column 'tblOrgRegistrations.RegID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.