DECLARE @USERID CHAR(15)
DECLARE @CMPNYNAM CHAR(30)
 
SET @USERID = 'testuser'
SET @CMPNYNAM = 'Fabrikam, Inc.'
 
/*Deleting the user record from the DEX_LOCK table*/
DELETE  FROM tempdb.dbo.DEX_LOCK
WHERE   session_id = ( SELECT   SQLSESID
                       FROM     DYNAMICS.dbo.ACTIVITY
                       WHERE    USERID = @USERID
                                AND CMPNYNAM = RTRIM(@CMPNYNAM)
                     )
 
/*Deleting the user record from the DEX_SESSION table*/
DELETE  FROM tempdb.dbo.DEX_SESSION
WHERE   session_id = ( SELECT   SQLSESID
                       FROM     DYNAMICS.dbo.ACTIVITY
                       WHERE    USERID = @USERID
                                AND CMPNYNAM = RTRIM(@CMPNYNAM)
                     )
 
/*Deleting the user record from the SY00801 table*/
DELETE  FROM DYNAMICS.dbo.SY00801
WHERE   USERID = @USERID
        AND CMPANYID = ( SELECT CMPANYID
                         FROM   DYNAMICS.dbo.SY01500
                         WHERE  CMPNYNAM = RTRIM(@CMPNYNAM)
                       )
 
/*Deleting the user record from the SY00800 table*/
DELETE  FROM DYNAMICS.dbo.SY00800
WHERE   USERID = @USERID
        AND CMPNYNAM = RTRIM(@CMPNYNAM)
 
/*Deleting the user record from the ACTIVITY table*/
DELETE  FROM DYNAMICS.dbo.ACTIVITY
WHERE   USERID = @USERID
        AND CMPNYNAM = RTRIM(@CMPNYNAM)