摘要: DECLARE @UserID INT; --推广员帐号 DECLARE @ProxyID INT; --代理帐号 DECLARE @Score INT=1000; --分数 SELECT @UserID = [SpreaderID] FROM [QPAccountsDB].[dbo].[AccountsInfo] WHERE UserID = 5055; SELECT ... 阅读全文
posted @ 2018-08-20 19:52 兰博丶专属 阅读(703) 评论(0) 推荐(0)
摘要: with cte as ( select belongsAgent from [QPProxyDB].[dbo].[BS_ProxyInfo] where ProxyID = @ProxyID union all select a.ProxyID from [QPProxyDB].[dbo].[BS_ProxyInfo] a join cte b on a.ProxyID = b.belong... 阅读全文
posted @ 2018-08-20 17:07 兰博丶专属 阅读(367) 评论(0) 推荐(0)