Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
The combined query used to fill mu datagrid currently: SELECT transID, DateFund, MaxVol, SUM(ln_amount) As SchVol, SUM(a_wire_amt) As WireVol FROM tblDTA D, lock L where D.Datefund= L.date_fund and D.datefund=L.a_wire_date and Datefund between '01/01/2009' and '02/12/2009' group by datefund, maxvol, transid The query above produces ONLY 3 rows for Datefund between '01/01/2009' and '02/12/2009'. It should show 43 rows with results for each of 43 dates If I separate this query into 3 basic ones: Query 1: select datefund, maxvol from tblDTA where datefund between '01/01/2009' and '02/12/2009' (this query produces 43 rows showing 43 days since Jan 1 and MaxVol = 0 - by default) Query 2: select a_wire_dat, sum(a_wire_amt) as WireVol from lock where a_wire_dat between '01/01/2009' and '02/12/2009' group by a_wire_dat (this query produces 29 rows showing 29 days where a_wire_dat actually exists) In datagrid I must somehow show the other 14 days where a_wire_dat does not exist as WireVol = 0 Query 3: select date_fund, sum(ln_amount)SchVol from lock where date_fund between '01/01/2009' and '02/12/2009' group by date_fund (this query produces 35 rows showing 35 days where date_fund actually exists) In datagrid I must somehow show the other 8 days where date_fund does not exist as WireVol = 0
|asp.net c# read lines of text file and put each row in mutliple variables variables not updated||3||29|
|Calculating total percentage per row in Oracle Query||2||23|
|Data Dynamics Active Reports with VB.Net or a good compatible replacement ?||1||16|
|Help with copying data from file2 to file1 only when data element in File1 is empty using VB.NET||2||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!