Viewing 2 posts - 1 through 3 (of 3 total)
Actually I figured it out. I had to change the last Join from c.IndustryC = H.IndCode to i.IndustryC = H.IndCodeFROM cteInvoices iLeft Outer JOIN cteCreditNotes...
March 17, 2017 at 2:40 pm
#1933838
This is great! Thank you!I had to add a semi colon before the With clause and now it gives me correct figures in 2 columns. There is just one...
March 17, 2017 at 2:23 pm
#1933836