View Full Version : SQL Stored Procedure Progress
Is it posible to get the progress of a stored procedure? If not, is it possible to run a thread to make a progressbar type control scroll while the procedure is running? Everytime i try to make a thread to run either the stored procedure or the progressbar control the program freezes on the stored procedure. Regards AJ |
Hi Brenda, Thanks for your reply. Here is my Stored Proc: CREATE PROCEDURE [TotalCostUpdate] AS DECLARE @ID INT, @Rate Real, @HourCost Real, @Employee nvarchar(18), @Hours Real, @Date Char(8) DECLARE SheetList CURSOR FOR SELECT TSNO, EMPLOYEE, HOURS, CONVERT(Char(8), [Date], 112) as [Date] FROM TSHEET OPEN SheetList FETCH NEXT FROM SheetList INTO @ID, @Employee, @Hours, @Date WHILE @@FETCH_STATUS = 0 BEGIN SET @HourCost = 0 SET @Rate = 0 SELECT @Rate = CASE MONTH(@Date) WHEN 1 THEN RATE1 WHEN 2 THEN RATE2 WHEN 3 THEN RATE3 WHEN 4 THEN RATE4 WHEN 5 THEN RATE5 WHEN 6 THEN RATE6 WHEN 7 THEN RATE7 WHEN 8 THEN RATE8 WHEN 9 THEN RATE9 WHEN 10 THEN RATE10 WHEN 11 THEN RATE11 WHEN 12 THEN RATE12 END FROM CORATE WHERE YEAR = Left(@Date, 4) AND EMPLOYEE = @Employee SET @HourCost = ISNULL(@Hours, 0) * ISNULL(@Rate, 0) UPDATE TSHEET SET COST = @HourCost WHERE TSNO = @ID FETCH NEXT FROM SheetList INTO @ID, @Employee, @Hours, @Date END CLOSE SheetList DEALLOCATE SheetList GO Just to clarify, the program just freezes until the stored proc has finished. Is there a way to make the program usable while the staored proc is running? Thanks AJ |