Why Does This Procedure Takes 25 Mins To Run

hi, this stored procedure below takes 25 mins to execute. is this normal? and is there a faster way to do this? its not like i have millions of records, i only have about 170.





Create Procedure sp_PayrollComplete





AS


declare @weDate nvarchar(10)





Select @weDate= we FROM cbetts.tblArchive


WHERE we = (select max(convert(datetime,we)) from cbetts.tblarchive)





declare @uid int


declare @job nvarchar(10)


declare @name nvarchar(30)


declare @Location nvarchar(30)


declare @Direct float


declare @LBO float


declare @g1099 float


declare @agency float


declare @nonbill float


declare @holiday float


declare @vacation float


declare @total float





delete cbetts.tblpayroll





Declare payroll_cursor CURSOR FOR


SELECT distinct userid FROM cbetts.v_PayrollTotals


where (we = @weDate)


ORDER BY userid





OPEN payroll_cursor





-- Perform the first fetch.


FETCH NEXT FROM payroll_cursor into @uid


-- Check @@FETCH_STATUS to see if there are any more rows to fetch.


WHILE @@FETCH_STATUS = 0


BEGIN





select @location=location from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


select @name = name from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


select @Direct =


sum(totals) from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and employeetype='direct'


and left(jobno,3) != '900'


select @LBO =


sum(totals) from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and employeetype='LBO'


select @g1099 =


sum(totals)from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and employeetype='1099'


select @agency =


sum(totals) from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and employeetype='Agency'


select @nonbill=


sum(totals) from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and left(jobno,3)='900'


select @holiday =


sum(totals) from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and (jobno='90010' or jobno='90011')


select @vacation =


sum(totals) from cbetts.v_payrolltotals


where userid = @uid


and we = @weDate


and jobno='90020'





set @total = ISNULL(@direct,0) + ISNULL(@lbo,0) + ISNULL(@g1099,0) + ISNULL(@agency,0) + ISNULL(@nonbill,0) + ISNULL(@holiday,0) + ISNULL(@vacation,0)


set @nonbill = ISNULL(@nonbill,0) - (ISNULL(@holiday,0) + ISNULL(@vacation,0))





insert into cbetts.tblpayroll (Name,userid,location,direct,lbo,g1099,agency,nonbill,holiday,vacation)


values (@name,@uid,@location,ISNULL(@direct,0), ISNULL(@lbo,0), ISNULL(@g1099,0), ISNULL(@agency,0),ISNULL(@nonbill,0), ISNULL(@holiday,0), ISNULL(@vacation,0))








FETCH NEXT FROM payroll_cursor into @uid





END





CLOSE payroll_cursor


DEALLOCATE payroll_cursor





-- get rid of the 0 hour entries


delete cbetts.tblpayroll


where total = 0











GO