select cast(amountsum as varchar(10))+'×'+boxsize+boxtype as BoxInfo,conid
from (SELECT SUM(Amount) AS amountsum, BoxSize, BoxType, ConID
FROM T_PlanBox
GROUP BY ConID, BoxSize, BoxType) mm查出:boxinfo conid
23×20'GP 12312321
12×20'OT 12312321想要看到的信息是:
boxallinfo conid
23×20'GP/12×20'OT 12312321该怎么实现亚!
from (SELECT SUM(Amount) AS amountsum, BoxSize, BoxType, ConID
FROM T_PlanBox
GROUP BY ConID, BoxSize, BoxType) mm查出:boxinfo conid
23×20'GP 12312321
12×20'OT 12312321想要看到的信息是:
boxallinfo conid
23×20'GP/12×20'OT 12312321该怎么实现亚!
解决方案 »
- 姐夫可以对小姨子说“不”吗?
- 菜鸟求教:在使用adoquery1.parambyname中为什么出现[Error]Undeclared identifier: 'parambyname'
- 我的分值如何提高呀
- 如何导出打开的EXCEL程序中表格的数据到sql数据库{表中的数据是实时更新的不能保存为xls文件再打开}
- 如何取得键盘上同时按下的两个或更多个的键?比如space+a+b+c
- Tdxtreelist 如何内嵌 combobox ?
- 请问windows时如何识别进程已经死掉了?
- 进程A和被注入的进程B的DLL之间 如何通过键盘消息进行通讯
- 请教:SQL中动态数据表如何进行查询?
- 关于存储过程的问题?
- 大型成大熟erp大软件技术转让
- 注册表问题(我先描述请您解答)
+ '×' + boxsize + 'GP/' + cast(amountsum_ot AS varchar(10))
+ '×' + boxsize + 'OT' AS BoxInfo, conid
FROM (SELECT SUM(CASE BoxType WHEN 'GP' THEN Amount ELSE 0 END)
AS amountsum_gp,
SUM(CASE BoxType WHEN 'OT' THEN Amount ELSE 0 END)
AS amountsum_ot, BoxSize, BoxType, ConID
FROM T_PlanBox
GROUP BY ConID, BoxSize) mm
+ '×' + boxsize + 'GP/' + cast(amountsum_ot AS varchar(10))
+ '×' + boxsize + 'OT' AS BoxInfo, conid
FROM (SELECT SUM(CASE BoxType WHEN 'GP' THEN Amount ELSE 0 END)
AS amountsum_gp,
SUM(CASE BoxType WHEN 'OT' THEN Amount ELSE 0 END)
AS amountsum_ot, BoxSize, BoxType, ConID
FROM T_PlanBox
GROUP BY ConID, BoxSize) mm
GROUP BY CONID
boxinfo conid
23×20'GP 12312321
12×20'OT 12312321
再转化:而且GP OT 都不是固定的
boxallinfo conid
23×20'GP/12×20'OT 12312321
该怎么办,如果用在程序中写,该怎么实现。遍历马?
Create Table 表(boxinfo varchar(10),conid varchar(10))
--插入数据
insert into 表
select '23×20''GP','12312321' union
select '12×20''OT','12312321'
--测试语句
go
CREATE FUNCTION FunMergeCharField(@vchA varchar(10))
RETURNS varchar(40)
AS
BEGIN
DECLARE @r varchar(40)
SET @r=''
SELECT @r=@r+','+boxinfo FROM 表 WHERE conid=@vchA
RETURN(substring(@r,2,8000))
END
GOselect dbo.FunMergeCharField(conid) as boxinfo,conid from 表 group by conid
--删除测试环境
Drop Table 表
drop function FunMergeCharField/*
boxinfo conid
---------------------------------------- ----------
12×20'OT,23×20'GP 12312321
*/