create proc UInfo(@Uid varchar(36))
as
begin
declare @ResultDt table(cname varchar(64),acount int,ccount int,scount int)
set @Uid='simao'
declare @tempcount int
insert into @ResultDt select
'商鋪 ',(select count(1) from ShopOffice where
UID=@Uid),(select count(1) from ShopOffice where SCommand=1 and
UID=@Uid),(select count(1) from ShopOffice where NStatus=3 and
UID=@Uid)
insert into @ResultDt select
'寫字樓',(select count(1) from OfficeBuilding where
UID=@Uid),(select count(1) from OfficeBuilding where SCommand=1 and
UID=@Uid),(select count(1) from OfficeBuilding where NStatus=3 and
UID=@Uid)
insert into @ResultDt select
'工業(yè)地產(chǎn)',(select count(1) from Industrial where
UID=@Uid),(select count(1) from Industrial where SCommand=1 and
UID=@Uid),(select count(1) from Industrial where NStatus=3 and
UID=@Uid)
insert into @ResultDt select
'大型項目',(select count(1) from Project where
UID=@Uid),(select count(1) from Project where SCommand=1 and
UID=@Uid),(select count(1) from Project where NStatus=3 and
UID=@Uid)
insert into @ResultDt select
'生意轉(zhuǎn)讓',(select count(1) from Bussiness where
UID=@Uid),(select count(1) from Bussiness where SCommand=1 and
UID=@Uid),(select count(1) from Bussiness where NStatus=3 and
UID=@Uid)
insert into @ResultDt select
'合計',sum(acount),sum(ccount),sum(scount) from @ResultDt
select * from @ResultDt
end
posted on 2010-10-15 00:15
sanmao 閱讀(713)
評論(0) 編輯 收藏