Skip to Content
0
Mar 04, 2019 at 09:25 PM

GROUP BY CLAUSE HELP

114 Views Last edit Mar 20, 2019 at 06:08 AM 4 rev

HELLO FOLKS

I AM RUNNING THIS BELOW QUERY AND I DIDN'T GET WHY IS REPEATING ROWS. CAN YOU PLEASE ADVISE WHAT'S WRONG WITH THIS QUERY. I NEED TO HAVE SINGLE LINE RESULT FOR BELOW QUERY.

SELECT 
T4.[ItemCode], 
T4.[Dscription], 
T2.[FirmName], 
SUM(T3.[OnHand]) as 'On Hand', 
Case when T4.[ShipDate] < getdate() then Sum(T4.[Quantity]) end as 'BO',
case when T4.[ShipDate] > getdate() then Sum(T4.[Quantity]) end as 'FC' 

FROM 

OITM T0 

INNER JOIN OITB T1 ON T0.[ItmsGrpCod] = T1.[ItmsGrpCod] 
INNER JOIN OMRC T2 ON T0.[FirmCode] = T2.[FirmCode] 
INNER JOIN OITW T3 ON T0.[ItemCode] = T3.[ItemCode] 
INNER JOIN RDR1 T4 ON T0.[ItemCode] = T4.[ItemCode] 

WHERE 

T3.[WhsCode] = '100' and
T4.[LineStatus] = 'O'


GROUP BY 

T4.[ItemCode], 
T4.[Dscription],
T2.[FirmName],
T4.[ShipDate]

bo-fc.jpg

Attachments

bo-fc.jpg (25.5 kB)