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 ProspectID, Prospect, ContEnd_Switch, TargetPrice, SUM(MwhAct * Total) / SUM(MwhAct) AS WAverage, GM_MarRate, Comm_1_Rate, Comm_2_Rate, Comm_3_Rate, Comm_4_Rate, Comm_5_Rate, Comm_6_Rate FROM Prospect_Cogs WHERE (Fwd_Mth BETWEEN 1 AND 12) and SRID = 176 and (Realtime in (select Realtime from tbl_realtime) ) GROUP BY ProspectID, Prospect, TargetPrice, ContEnd_Switch, GM_MarRate, Comm_1_Rate, Comm_2_Rate, Comm_3_Rate, Comm_4_Rate, Comm_5_Rate, Comm_6_Rate having SUM(MwhAct * Total) / SUM(MwhAct) > 0 order by CASE 0 when 1 then cast(ContEnd_Switch as varchar) -- by end contract when 2 then cast(TargetPrice as varchar) -- Target Price when 3 then cast(SUM(MwhAct * Total) / SUM(MwhAct) as varchar) --by quoted Price else Prospect --by Prospect Name END
|Why do I get extra rows when I do inner join?||12||38|
|SQL Trigger or Function that updates table with old values||5||37|
|Delete from table||6||44|
|ISDATE() not working properly on my table? Any suggestions.||7||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!