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.
with p as ( select TR.[Generic Code], TR.NDC, TR.[Drug Name], Sum(cast(TR.[Qty] as int)) as Qty from vw_Test3 TR Group By TR.[Generic Code], TR.NDC,TR.[Drug Name] ) select x.[Generic Code], x.NDC, x.[Drug Name], y.Qty from ( select p.*, row_number() over (partition by [Generic Code] order by Qty desc) rn from p ) x left join ( select [Generic Code], sum(cast(Qty as int)) Qty from p group by [Generic Code] ) y on x.[Generic Code]=y.[Generic Code] where rn=1;
|Sql server Transfering records getting error #NAME?||6||39|
|How to use odbc in vb to connect to ms sql||14||34|
|How to use left join to take all data from master table?||11||45|
|SYNTAX PROBLEM -- adding another column into the stored procedure output||30||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!