Product Details
Product Information
Brand | Sharp |
SELECT a.PGNumb, SUM(Qty) Qty FROM ( SELECT l.PGNumb,c.CompanyName, CASE WHEN (edi.EDIUserName = '' OR edi.EDIPassword = '' OR edi.EDIUserName IS NULL) THEN 10000001 ELSE e.StockQty END Qty, ROW_NUMBER() OVER(PARTITION BY l.PGNumb ORDER BY CASE WHEN e.StockQty > 0 THEN 0 ELSE 1 END,h.PreferredYN DESC) rownum FROM CSLines l WITH (READUNCOMMITTED) LEFT JOIN (SystemExternalStock e JOIN Company c WITH (READUNCOMMITTED) ON c.AccCode = e.AccCode AND c.CompanyName IS NOT NULL JOIN CSHeader h WITH (READUNCOMMITTED) ON c.CompId = h.SupplierId JOIN CompanyEDISetup edi WITH (READUNCOMMITTED) ON edi.CompId = c.CompId ) ON e.PGNumb = l.PGNumb WHERE l.PGNumb IN (106703) ) a WHERE rownum = 1 GROUP BY a.PGNumb SELECT a.PGNumb, SUM(Qty) Qty FROM ( SELECT l.PGNumb,c.CompanyName, CASE WHEN (edi.EDIUserName = '' OR edi.EDIPassword = '' OR edi.EDIUserName IS NULL) THEN 10000001 ELSE e.StockQty END Qty, ROW_NUMBER() OVER(PARTITION BY l.PGNumb ORDER BY CASE WHEN e.StockQty > 0 THEN 0 ELSE 1 END,h.PreferredYN DESC) rownum FROM CSLines l WITH (READUNCOMMITTED) LEFT JOIN (SystemExternalStock e JOIN Company c WITH (READUNCOMMITTED) ON c.AccCode = e.AccCode AND c.CompanyName IS NOT NULL JOIN CSHeader h WITH (READUNCOMMITTED) ON c.CompId = h.SupplierId JOIN CompanyEDISetup edi WITH (READUNCOMMITTED) ON edi.CompId = c.CompId ) ON e.PGNumb = l.PGNumb WHERE l.PGNumb IN (126337,108730,113254,132611,122795,113218,103059) ) a WHERE rownum = 1 GROUP BY a.PGNumb
Brand | Sharp |