jafarpalideh
پنج شنبه 26 تیر 1393, 11:09 صبح
با سلام .
من کوئری زیر رو نوشتم .
SELECT TOP 100 PERCENT dbo.S_CUSTOMER.CUST_CD, dbo.S_CUSTOMER.CUST_NM, dbo.S_ODS.OD_CD, dbo.S_ODS.OD_NM,
SUM(dbo.S_DTL_FCT.QUANTITY) AS tedad, dbo.S_DTL_FCT.UN_PRC AS gheymatevahed, SUM(dbo.S_DTL_FCT.QUANTITY)
* dbo.S_DTL_FCT.UN_PRC AS MulResult, ROUND(SUM(dbo.S_DTL_FCT.QUANTITY) * dbo.J_kala.OD_Vazn / 1000, 0) AS Vazn_Mavad,
dbo.J_kala.OD_FE * ROUND(SUM(dbo.S_DTL_FCT.QUANTITY) * dbo.J_kala.OD_Vazn / 1000, 0) AS GH_Kol_MAV, SUM(dbo.S_DTL_FCT.QUANTITY)
/ dbo.J_kala.OD_TiK AS Tedad_Kar, SUM(dbo.S_DTL_FCT.QUANTITY) * dbo.S_DTL_FCT.UN_PRC / SUM(dbo.S_DTL_FCT.QUANTITY) AS FE_AVG
FROM dbo.S_CUSTOMER INNER JOIN
dbo.S_HED_FCT ON dbo.S_CUSTOMER.CUST_CD = dbo.S_HED_FCT.CUST_CD INNER JOIN
dbo.S_DTL_FCT ON dbo.S_HED_FCT.id = dbo.S_DTL_FCT.id INNER JOIN
dbo.S_ODS ON dbo.S_DTL_FCT.OD_CD = dbo.S_ODS.OD_CD INNER JOIN
dbo.J_kala ON dbo.S_ODS.OD_CD = dbo.J_kala.OD_CD
WHERE (dbo.S_DTL_FCT.Stock_cd = 1) AND (dbo.S_HED_FCT.Stock_cd = 1) AND (dbo.S_HED_FCT.Price_Kind = 2) AND (dbo.S_HED_FCT.TYPERH_CD = 2)
AND (dbo.S_HED_FCT.ACC_YEAR = 1393)
GROUP BY dbo.S_ODS.OD_CD, dbo.S_CUSTOMER.CUST_CD, dbo.S_DTL_FCT.UN_PRC, dbo.S_CUSTOMER.CUST_NM, dbo.S_ODS.OD_NM, dbo.J_kala.OD_CD,
dbo.J_kala.OD_Vazn, dbo.J_kala.OD_FE, dbo.J_kala.OD_TiK
ORDER BY dbo.S_CUSTOMER.CUST_CD
حالا وقتی میخوام اون رو تویه دیتا گرید نمایش بدم تویه چند تا از فیلدام صفر اضافه میندازه !!! نمیدونم مشکل از کجاست .
121190
من کوئری زیر رو نوشتم .
SELECT TOP 100 PERCENT dbo.S_CUSTOMER.CUST_CD, dbo.S_CUSTOMER.CUST_NM, dbo.S_ODS.OD_CD, dbo.S_ODS.OD_NM,
SUM(dbo.S_DTL_FCT.QUANTITY) AS tedad, dbo.S_DTL_FCT.UN_PRC AS gheymatevahed, SUM(dbo.S_DTL_FCT.QUANTITY)
* dbo.S_DTL_FCT.UN_PRC AS MulResult, ROUND(SUM(dbo.S_DTL_FCT.QUANTITY) * dbo.J_kala.OD_Vazn / 1000, 0) AS Vazn_Mavad,
dbo.J_kala.OD_FE * ROUND(SUM(dbo.S_DTL_FCT.QUANTITY) * dbo.J_kala.OD_Vazn / 1000, 0) AS GH_Kol_MAV, SUM(dbo.S_DTL_FCT.QUANTITY)
/ dbo.J_kala.OD_TiK AS Tedad_Kar, SUM(dbo.S_DTL_FCT.QUANTITY) * dbo.S_DTL_FCT.UN_PRC / SUM(dbo.S_DTL_FCT.QUANTITY) AS FE_AVG
FROM dbo.S_CUSTOMER INNER JOIN
dbo.S_HED_FCT ON dbo.S_CUSTOMER.CUST_CD = dbo.S_HED_FCT.CUST_CD INNER JOIN
dbo.S_DTL_FCT ON dbo.S_HED_FCT.id = dbo.S_DTL_FCT.id INNER JOIN
dbo.S_ODS ON dbo.S_DTL_FCT.OD_CD = dbo.S_ODS.OD_CD INNER JOIN
dbo.J_kala ON dbo.S_ODS.OD_CD = dbo.J_kala.OD_CD
WHERE (dbo.S_DTL_FCT.Stock_cd = 1) AND (dbo.S_HED_FCT.Stock_cd = 1) AND (dbo.S_HED_FCT.Price_Kind = 2) AND (dbo.S_HED_FCT.TYPERH_CD = 2)
AND (dbo.S_HED_FCT.ACC_YEAR = 1393)
GROUP BY dbo.S_ODS.OD_CD, dbo.S_CUSTOMER.CUST_CD, dbo.S_DTL_FCT.UN_PRC, dbo.S_CUSTOMER.CUST_NM, dbo.S_ODS.OD_NM, dbo.J_kala.OD_CD,
dbo.J_kala.OD_Vazn, dbo.J_kala.OD_FE, dbo.J_kala.OD_TiK
ORDER BY dbo.S_CUSTOMER.CUST_CD
حالا وقتی میخوام اون رو تویه دیتا گرید نمایش بدم تویه چند تا از فیلدام صفر اضافه میندازه !!! نمیدونم مشکل از کجاست .
121190