34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @GROUPCONT int
SET @GROUPCONT=2
SELECT
T2.*,T1.AGENT_ID
FROM
(SELECT ROW_NUM()OVER(ORDER BY AGENT_ID)RN,AGENT_ID FROM G) T1
JOIN ##t_2 T2 ON T1.RN = (T2.ID-1)/@GROUPCONT+1
DECLARE @GROUPCONT int
SELECT
T2.*,T1.AGENT_ID
FROM
(SELECT ROW_NUM()OVER(ORDER BY AGENT_ID)RN,AGENT_ID FROM G) T1
JOIN ##t_2 T2 ON T1.RN = (T2.ID-1)/@GROUPCONT+1
我更改了一些字段,因为GROUP是加关键字,我更改为实际情况的AGENT_ID,也用了真实的字段。
但是执行后,只是把表头跑出来,没有我要的结果。
SELECT
T2.*,T1.[GROUP]
FROM
(SELECT ROW_NUMBER()OVER(ORDER BY[GROUP])RN,[GROUP]FROM G)T1
JOIN T T2 ON T1.RN=(T2.ID-1)/@GROUPCOUNT+1