The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Working with AJAX Update progress control
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Ketan PatelPosted Jun 9, 2011, 11:41 PM
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- insert_demo_sp_Expriment '','A',10.10,'Country','' -- select * from tblLists ALTER Procedure [dbo].[insert_demo_sp_Expriment] ( @AutoID bigint, @RecordStatus varchar(max), @UpdateID decimal(9,2), @Code CHAR(20), @Order int ) AS BEGIN DECLARE @MyOutput decimal(9,2) DECLARE @MyLastOutput decimal(9,2) DECLARE @OrderNo INT Set @MyOutput = 0 set @MyLastOutput = 0 set @OrderNo = 0 select @MyOutput = MAX(UpdateID) from dbo.tblLists where Code = ''+ @Code +'' select @OrderNo = Max([Order]) from dbo.tblLists where Code = ''+ @Code +'' select @MyLastOutput = ROUND(MAX(UpdateID),1,1) from dbo.tblLists if(@MyOutput != 0) BEGIN INSERT INTO dbo.tblLists ( UpdateID, RecordStatus, Code, [Order] ) Values ( @MyOutput + 00.01, 'A', @Code, @OrderNo + 1 ) END else BEGIN INSERT INTO dbo.tblLists ( UpdateID, RecordStatus, Code, [Order] ) Values ( @MyLastOutput + 1, 'A', @Code, 1 ) END END
cuteboy thiruPosted Dec 13, 2010, 6:08 AM
i download and tried this sample in IE browser its working fine but in firebox its not working
Ravi KiranPosted Nov 11, 2009, 2:51 PM
Keep the good work up.. very nice article.