SELECT GO_Oper_NO,
MAX(CASE Card_Type WHEN 'A' THEN Card_Type_NUM ELSE '0' END) AS A,
MAX(CASE Card_Type WHEN 'B' THEN Card_Type_NUM ELSE '0' END) AS B,
MAX(CASE Card_Type WHEN 'B' THEN MoneyB ELSE '0' END) AS B收费
FROM(
SELECT GO_Oper_NO,Card_Type,COUNT(Card_Type) AS Card_Type_NUM ,sum(M_money) as MoneyB
FROM GoCar
WHERE Go_Date>='2008/07/30' AND Go_Date <'2008/07/31'
GROUP BY GO_Oper_NO,Card_Type
) B
GROUP BY GO_Oper_NO运行后提示“不允许从数据类型 varchar 到 money 的隐性转换。请使用 CONVERT 函数来运行此查询。”
我试着用了一下CONVERT 函数,还有format,ccur等函数,都不行,我该怎么做,请高手支招!最后能在函数上直接该了发上来
(M_money字段的类型是money,其余的都不是)
MAX(CASE Card_Type WHEN 'A' THEN Card_Type_NUM ELSE '0' END) AS A,
MAX(CASE Card_Type WHEN 'B' THEN Card_Type_NUM ELSE '0' END) AS B,
MAX(CASE Card_Type WHEN 'B' THEN MoneyB ELSE '0' END) AS B收费
FROM(
SELECT GO_Oper_NO,Card_Type,COUNT(Card_Type) AS Card_Type_NUM ,sum(M_money) as MoneyB
FROM GoCar
WHERE Go_Date>='2008/07/30' AND Go_Date <'2008/07/31'
GROUP BY GO_Oper_NO,Card_Type
) B
GROUP BY GO_Oper_NO运行后提示“不允许从数据类型 varchar 到 money 的隐性转换。请使用 CONVERT 函数来运行此查询。”
我试着用了一下CONVERT 函数,还有format,ccur等函数,都不行,我该怎么做,请高手支招!最后能在函数上直接该了发上来
(M_money字段的类型是money,其余的都不是)
不知道是不是我用的CONVERT ,format,ccur等函数方法不对,希望有高手能指点一下,最好在程序里改一下发上来
MAX(CASE Card_Type WHEN 'B' THEN MoneyB ELSE 0 END) AS B收费