>protected DataAccessLayer oDAL = new DataAccessLayer();
>protected sUserID = "user ID goes here";
>if (oDAL.Progress("QUERY", sUserID))
>{
> // do something
>}
>
>Parameters are: "START", "STOP", "QUERY" to signify in progress, or finished or check state.>ALTER PROCEDURE dbo.sp_InProgress >( > @action char(5) = 'QUERY', > @UserId char(10) = NULL >) >AS >SET NOCOUNT ON >IF @action NOT IN ('START','STOP','QUERY') SET @action = 'QUERY'; >IF @action = 'START' >BEGIN > IF EXISTS (SELECT InProgress FROM setup) > BEGIN > UPDATE setup > SET inprogress = 1, datetime = getDate(), who = @UserId > END > ELSE > BEGIN > INSERT INTO setup (datetime, inprogress, who) VALUES (getDate(), 1, @UserId) > END >END >ELSE >IF @action = 'STOP' >BEGIN > IF @UserId IS NULL > BEGIN > UPDATE setup > SET inprogress = 0, datetime = getDate() > END >ELSE > BEGIN > UPDATE setup > SET inprogress = 0, datetime = getDate(), who = @UserId > END >END >ELSE >-- 'QUERY' >BEGIN > SELECT * FROM setup >END >>