Database

If @Test = 1
   Execute [Procedure1];
Else If @Test = 2
   Execute [Procedure2];
Else If @Test = 3
   Execute [Procedure3];
Else
   Execute [Procedure4];

SELECT UNITS.ProductionNo, COUNT(UNITS.SerialNo) AS SHIPPED, 
COUNT(UNIT_Logs.SerialNo) AS PACKED
FROM UNITS JOIN UNIT_Logs
ON UNITS.ProductionNo = UNIT_Logs.ProductionNo
WHERE (UNITS.ScanStatus = 'SHIPPED') AND (UNIT_Logs.Old_Status = 'PACKED')
GROUP BY UNITS.ProductionNo, UNITS.ScanStatus, UNIT_Logs.Old_Status

SELECT UNITS.ProductionNo, 
   COUNT(UNITS.SerialNo) AS SHIPPED,
   COUNT(UNIT_Logs.SerialNo) AS PACKED
FROM UNITS 
   JOIN UNIT_Logs
      ON UNITS.ProductionNo = UNIT_Logs.ProductionNo
WHERE (UNITS.ScanStatus = 'SHIPPED') AND (UNIT_Logs.Old_Status = 'PACKED')
GROUP BY UNITS.ProductionNo

SELECT u.ProductionNo,
   u.SHIPPED,
   l.PACKED
FROM 
(
   SELECT ProductionNo, 
      COUNT(SerialNo) AS SHIPPED
   FROM UNITS 
   WHERE ScanStatus = 'SHIPPED'
   GROUP BY ProductionNo
) u
LEFT OUTER JOIN 
(
   SELECT ProductionNo, 
      COUNT(SerialNo) AS PACKED
   FROM UNIT_Logs 
   WHERE Old_Status = 'PACKED'
   GROUP BY ProductionNo  
) l
ON l.ProductionNo = u.ProductionNo

<<tash18>> wrote:

distinct records