CREATE PROCEDURE birdincome_zf
AS
declare @actionid integer
declare @mid varchar(100)
declare @service_id varchar(100)
declare case1 cursor for
SELECT mid,service_id from bird_user_2006_03 where type=0
declare case2 cursor for
SELECT mid,service_id from bird_user_2006_03 where type=1
open case1
fetch next from case1 into @mid,@service_id
while (@@fetch_status=0)
begin
select top 1 @actionid=bb.actionid from operation_temp_0526 as bb
where bb.serviceid=@service_id and bb.mid=@mid
order by bb.id desc
if (@actionid=1)
insert into bird_user_2006_04(mid,service_id,type,portal_id) values(@mid,@service_id,'1','10000')
else
print 'ooooooo'
fetch next from case1 into @mid,@service_id
end
deallocate case1
open case2
fetch next from case2 into @mid,@service_id
while (@@fetch_status=0)
begin
select top 1 @actionid=bb.actionid from operation_temp_0526 as bb
where bb.serviceid=@service_id and bb.mid=@mid
order by bb.id desc
if (@actionid != 2)
insert into bird_user_2006_04(mid,service_id,type,portal_id) values(@mid,@service_id,'2','10000')
fetch next from case2 into @mid,@service_id
end
deallocate case2
GO