--楼主所说的进一个星期的概念是不是这样,上周三到今天算一个星期,是以今天日期为准-7? select id,username from [user] where datediff(dd,loginLastTime,getdate())<=7
--如果要找出会员人数,那就这样 select count(distinct username) from [user] where datediff(dd,loginLastTime,getdate())<=7 --把会员依依存到另一张表中,就这样。 insert othertable select distinct username from [user] where datediff(dd,loginLastTime,getdate())<=7 --不管你怎么实现,肯定要调用数据库来实现。
select * into newTable from [user] where loginLastTime>dateadd(day, -7, getdate())
insert into ActiveMember_temp select userid,username,lastlogin from dv_user where LastLogin>=getdate()-7 and LastLogin!=JoinDate order by lastlogin desc--为要存的表 CREATE TABLE [dbo].[ActiveMember_temp] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [uid][int] NULL, [uname][varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , [lastlogin][datetime] NULL, [AddTime] [datetime] default getdate() )这样的话说不匹配,怎么改改。。
insert into ActiveMember_temp(uid,uname,lastlogin) select userid,username,lastlogin from dv_user where LastLogin>=getdate()-7 and LastLogin!=JoinDate order by lastlogin desc这样就行了。谢谢 知道了我
select id,username from [user] where datediff(dd,loginLastTime,getdate())<=7
select count(distinct username) from [user] where datediff(dd,loginLastTime,getdate())<=7
--把会员依依存到另一张表中,就这样。
insert othertable select distinct username from [user] where datediff(dd,loginLastTime,getdate())<=7
--不管你怎么实现,肯定要调用数据库来实现。
into newTable
from [user]
where loginLastTime>dateadd(day, -7, getdate())
select * into #newtable from [user] where ......
insert into ActiveMember_temp select userid,username,lastlogin from dv_user where LastLogin>=getdate()-7 and LastLogin!=JoinDate order by lastlogin desc--为要存的表
CREATE TABLE [dbo].[ActiveMember_temp] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[uid][int] NULL,
[uname][varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[lastlogin][datetime] NULL,
[AddTime] [datetime] default getdate()
)这样的话说不匹配,怎么改改。。