ASP怎样实现记录合并查询

将表里的数据，合并为这样的效果；

 

if exists(select * from sysobjects where name='itpub' and type='u')
drop table itpub

 

--创建一个表

create table [dbo].[itpub](
id int ,
munid int,
item varchar(100))

--象表里面插如记录
insert [itpub] select 1,102,'BAGS ' union all
select 2,102,'SWATCH ' union all
select 3,105,'TEA' union all
select 4,105,'T_SHIRTS'

GO

--创建一个函数，将item合并到一起
create function itpub_fun(@munid int) returns varchar(8000)
as
begin
declare @item varchar(8000)

set @item=''
select @item=@item+rtrim(item)+' ' from itpub where munid=@munid
set @item=rtrim(@item)
return @item
end

GO

--创建一个函数，将id加起来
create function itpub_ALL(@munid int) returns int
as
begin
declare @i int

set @i=0
select @i=@i+rtrim(id) from itpub where munid=@munid
set @i=rtrim(@i)
return @i
end

GO

 

select munid,dbo.itpub_fun(munid), dbo.itpub_ALL(munid)item from itpub group by munid