34,838
社区成员




select top 3 '杂志分析','1','杂志下载最多',ObjectID,count(ObjectID) mcount,
(select ml.[Name] from MagazineDetail md inner join MagazineList ml on md.MagazineCode=ml.Code where md.Code=#userb1.ObjectID) as mname
from #userb1
where EventName='DownloadMagazine'
group by ObjectID
order by mcount desc
create table #result(
[td0] [int] IDENTITY (1, 1) NOT NULL ,
[td1] [nvarchar] (150) NULL,
[td2] [nvarchar] (150) NULL,
[td3] [nvarchar] (150) NULL ,
[td4] [nvarchar] (150) NULL ,
[td5] [nvarchar] (150) NULL ,
[td6] [nvarchar] (150) NULL
)
insert into #result (td1,td2,td3,td4,td5,td6)
select top 3 '杂志分析','1','杂志下载最多',ObjectID,count(ObjectID) mcount,
(select ml.[Name] from MagazineDetail md inner join MagazineList ml on md.MagazineCode=ml.Code where md.Code=#userb1.ObjectID) as mname
from #userb1
where EventName='DownloadMagazine'
group by ObjectID
order by mcount desc
select * from #result order by td0
drop table #result
create table #result(
[td0] [int] IDENTITY (1, 1) NOT NULL ,
[td1] [nvarchar] (150) NULL,
[td2] [nvarchar] (150) NULL,
[td3] [nvarchar] (150) NULL ,
[td4] [nvarchar] (150) NULL ,
[td5] [nvarchar] (150) NULL ,-- ===>这里改为int
[td6] [nvarchar] (150) NULL
)