I have two Tables :-
I need to Add BalanceReport.Qty to TransactionReport.Qty for its Corresponding NDC Column
Incase if NDC is not matching, then i need to just include the BalanceReport - NDC:Qty to Transaction Report.
I really need experts help to resolve this issue
select Id,NDC,Qty,CreatedDate from BalanceReport
Sum([Dispensed Qty]) as TotalDispensed
Group By GenericCode,NDC