如何获取动态列的值 [英] How to get the value for dynamic column

问题描述

我正在对select语句使用以下查询

I am using following query for select statement

SELECT	GODOWNNAME,  ITEMCODE,      ITEMNAME,
        STOCKQUANTITY as OPEN_QTY,  CLOSINGQTY,
       ''PUR_QTY''  =  ISNULL(PURCHASEQUANTITY,0) + ISNULL(SALESRTNQTY,0) ,
       ''SAL_QTY'' =   ISNULL(PURCHASERTNQTY,0) + ISNULL(SOLDQUANTITY,0),  
FROM	@GODOWN_STOCK WHERE ITEMSRLNO=@ITEMSNO AND (''PUR_QTY''+''SAL_QTY''+STOCKQUANTITY+CLOSINGQTY)<>0
		ORDER	BY	GODOWNSRLNO,	ITEMCODE

但是显示错误，我们无法将varchar转换为数字.如何计算动态列PUR_QTY，SAL_QTY的值

请帮我谢谢你

But the error is displayed we cannot convert varchar to numeric. How to calculate the values for dynamic columns PUR_QTY , SAL_QTY

Please help me thank you

推荐答案

尝试:

SELECT	
     GODOWNNAME,  
     ITEMCODE,      
     ITEMNAME,
     STOCKQUANTITY as OPEN_QTY,  
     CLOSINGQTY,
     (ISNULL(PURCHASEQUANTITY,0) + ISNULL(SALESRTNQTY,0)) AS PUR_QTY,
     (ISNULL(PURCHASERTNQTY,0) + ISNULL(SOLDQUANTITY,0)) AS SAL_QTY,  
FROM	
     @GODOWN_STOCK 
WHERE 
     ITEMSRLNO=@ITEMSNO 
     AND 
     (PUR_QTY+SAL_QTY+STOCKQUANTITY+CLOSINGQTY)<>0
ORDER BY	
     GODOWNSRLNO,	
     ITEMCODE

这篇关于如何获取动态列的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！