chokka
asked on
Adding Output from two SQL Scripts
SQL 2008
I have two Tables :-
BalanceReport
TransactionReport
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
I have two Tables :-
BalanceReport
TransactionReport
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
select GenericCode,
NDC,
Sum([Dispensed Qty]) as TotalDispensed
from TransactionReport
Group By GenericCode,NDC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
ASKER
Anyways thank you for your help
Open in new window