22,209
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#A') is null
drop table #A
Go
Create table #A([ID] int,[用户名] nvarchar(22),[在线时间] DATETIME)
Insert #A
select 1,N'张三',N'2018-9-8 12:59:00' union all
select 2,N'李四',N'2018-9-3 12:54:00' union all
select 3,N'王五',N'2018-9-1 12:51:00'
GO
if not object_id(N'Tempdb..#B') is null
drop table #B
Go
Create table #B([ID] int,[用户名] nvarchar(22),[分享号名] nvarchar(23),[分享最大值] int)
Insert #B
select 1,N'张三',N'张1山',0 union all
select 2,N'张三',N'张2山',0 union all
select 3,N'李四',N'李1四',0 union all
select 4,N'李四',N'李2四',0 union all
select 5,N'王五',N'王1五',0 union all
select 6,N'王五',N'王2五',0
Go
--测试数据结束
UPDATE
#B
SET
分享最大值 =ABS(CHECKSUM(NEWID())%3)+1
FROM
#A
WHERE
#A.用户名 = #B.用户名
AND DATEDIFF(DAY, GETDATE(), 在线时间) = 0
SELECT * FROM #B