Hi all. Hope you are all doing well.
Easy one...
In the Union query below (below the XX's) I need to
Group by:
AsOf,
AcctKey,
SecKey,
PositionRef
and
Sum By:
Quantity_Impact,
MarketVal_Impact,
Cash_Impact,
Thanks
XXXXXXXXXXXXX
SELECT
AsOf,
AcctKey,
SecKey,
Quantity_Impact,
MarketVal_Impact,
Cash_Impact,
PositionRef
FROM Activity_Cash_1;
UNION ALL SELECT
AsOf,
AcctKey,
SecKey,
Quantity_Impact,
MarketVal_Impact,
Cash_Impact,
PositionRef
FROM Activity_Security_1;
Easy one...
In the Union query below (below the XX's) I need to
Group by:
AsOf,
AcctKey,
SecKey,
PositionRef
and
Sum By:
Quantity_Impact,
MarketVal_Impact,
Cash_Impact,
Thanks
XXXXXXXXXXXXX
SELECT
AsOf,
AcctKey,
SecKey,
Quantity_Impact,
MarketVal_Impact,
Cash_Impact,
PositionRef
FROM Activity_Cash_1;
UNION ALL SELECT
AsOf,
AcctKey,
SecKey,
Quantity_Impact,
MarketVal_Impact,
Cash_Impact,
PositionRef
FROM Activity_Security_1;