SELECT
code.PRODUCT_CODE_ proCode,
code.PRODUCT_NAME_ proName,
SUM (res.incount) incount,
SUM (res.discount) - SUM (res.drawcount) discount
FROM
GF_PRODUCT_CODE_ code
LEFT JOIN (
SELECT
storage.PRODUCT_ID_ proId,
ISNULL(storage.T_STORAGE_COUNT_, 0) incount,
ISNULL(storage.T_DISCHARGE_COUNT_,0) discount,
ISNULL(storage.T_DRAW_COUNT_, 0) drawcount
FROM
GF_PRODUCT_STORAGE_ storage
WHERE
1 = 1
AND MONTH (storage.STORAGE_TIME_) = 9 AND YEAR (storage.STORAGE_TIME_) = 2015
) res ON res.proId LIKE (code.PRODUCT_CODE_ + '%')
WHERE
code.FATHER_CODE_ IS NULL
GROUP BY
code.PRODUCT_CODE_,
code.PRODUCT_NAME_
ORDER BY
code.PRODUCT_CODE_ ASC
select top 1 product_date from [dbo].[st_code_box]
where Convert(varchar(10),product_date,20) = Convert(varchar(10),getDate(),20) and line_code=103
order by product_date desc