SELECT NOSO,SUM(QTYREJ) QTY
FROM scrap
WHERE '20030930'>=convert(varchar(8),dt,112) and convert(varchar(8),dt,112)>='20030501'
GROUP BY NOSO
FROM scrap
WHERE '20030930'>=convert(varchar(8),dt,112) and convert(varchar(8),dt,112)>='20030501'
GROUP BY NOSO
FROM scrap
WHERE '20030930'>=dt and dt>='20030501'
GROUP BY NOSO
FROM scrap
WHERE dt between '20030501' and '20030930'
GROUP BY NOSO
SELECT NOSO,SUM(QTYREJ) QTY
FROM scrap
WHERE '20030930'>=convert(varchar,dt,112)+datename(month,dt)+datename(day,dt)>='20030501'
GROUP BY NOSO
--改为:
SELECT NOSO,SUM(QTYREJ) QTY
FROM scrap
WHERE '20030930'>=convert(varchar,dt,112)>='20030501'
GROUP BY NOSO
或者:SELECT NOSO,SUM(QTYREJ) QTY
FROM scrap
WHERE convert(varchar,dt,112) between '20030930' and '20030501'
GROUP BY NOSO
问题解决了,就用convert()