显示该扣分的用户和贴子信息,供参考
select
t.MemberID,
t.TopicID,
(getdate()-t.AddedDate) 未结贴时间
from Topics t,Reply r,Member m
where t.TOpicID=r.TopicID and
m.MemberID=t.MemberID and
未结贴时间>三个月 and
t.IsClosed=0
group by t.MemberID,t.TopicID,t.AddedDate
having sum(r.ReplyID)>3
select
t.MemberID,
t.TopicID,
(getdate()-t.AddedDate) 未结贴时间
from Topics t,Reply r,Member m
where t.TOpicID=r.TopicID and
m.MemberID=t.MemberID and
未结贴时间>三个月 and
t.IsClosed=0
group by t.MemberID,t.TopicID,t.AddedDate
having sum(r.ReplyID)>3
select
@tempID=t.MemberID,
t.TopicID,
(getdate()-t.AddedDate) 未结贴时间
from Topics t,Reply r,Member m
where t.TOpicID=r.TopicID and
m.MemberID=t.MemberID and
未结贴时间>三个月 and
t.IsClosed=0
group by t.MemberID,t.TopicID,t.AddedDate
having sum(r.ReplyID)>3update member set credits=credits-5 where memberID=@@tempID