CREATE PROCEDURE [dbo].[up_get_keymap] ( @auth_id [uniqueidentifier] ) AS BEGIN set nocount on declare @get_AuthID [uniqueidentifier]; SET @get_AuthID = NULL; SELECT TOP 1 @get_AuthID = AuthID FROM KeyMapTable with (READUNCOMMITTED) WHERE AuthID = @auth_id; IF( @get_AuthID IS NULL ) BEGIN insert into KeyMapTable values( @auth_id, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ); END SELECT TOP 1 * FROM KeyMapTable with (READUNCOMMITTED) WHERE AuthID = @auth_id END