1,216
社区成员
发帖
与我相关
我的任务
分享
-- 假设表名为 T
SELECT pattern, IDENTITY(INT) flg
INTO TX
FROM T
WHERE NOT EXISTS (
SELECT *
FROM T AS TT
WHERE TT.pattern = T.pattern
AND TT.ID < T.ID
)
;
UPDATE T
SET T.flg = TX.flg
FROM TX
WHERE TX.pattern = T.pattern;
DROP TABLE TX;
rsx.CursorLocation = adUseClient
Set rsx = conn.Execute("select distinct pattern from tb order by pattern")
n = 1
While Not rsx.EOF
conn.Execute "update tb set flg=" & n & " where pattern='" & rsx(0) & "'"
rsx.MoveNext
n = n + 1
Wend
Set rsx = conn.Execute("select distinct pattern,flg from tb order by [id]")
n = 1
Do While Not rsx.EOF
conn.Execute "update tb set flg = " & n & " where pattern= '" & rsx!pattern & "'"
rsx.MoveNext
n = n + 1
Loop