Viewing 3 posts - 1 through 4 (of 4 total)
Hello again!
Sadly my problem still exists. This query right here:
SELECT
ca.CountryName,
cb.CountryName,
SUM((case when ca.CountryName < cb.CountryName then -1 else 1 end) * CONVERT(money, (od.UnitPrice * od.Quantity) * (1 - od.Discount)...
May 4, 2018 at 5:11 am
April 27, 2018 at 8:15 am
I had some time to work on it, now I have this query:
SELECT
MAX(ca.CountryName) as CountryA,
MIN(cb.CountryName) as CountryB,
SUM((case when ca.CountryName < cb.CountryName then...
April 27, 2018 at 7:05 am
Viewing 3 posts - 1 through 4 (of 4 total)