ALTER PROCEDURE [dbo].[Check_Username]
	-- Add the parameters for the stored procedure here
	@Username nvarchar (255),
	@User_ID bigint = 0
AS
set Nocount on
Declare	@Check_User_ID bigint = 0
SELECT @Check_User_ID = Users.User_ID from Users where Username = @Username and Users.User_ID <> @User_ID
return @Check_User_ID

DECLARE	@return_value int

EXEC	@return_value = [dbo].[Check_Username]
		@Username = N'SEFL',
		@User_ID = 0

SELECT	'Return Value' = @return_value

GO

exec Check_Username 'SEFL', 0

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Check_Username]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[usp_Check_Username]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[usp_Check_Username]
	  @Username nvarchar (255)
	, @User_ID	bigint = 0
	, @rc		int OUTPUT
AS

SET NOCOUNT ON

SELECT @rc = COUNT(*)
  FROM [Users]
 WHERE [UserName]	= @UserName
   AND [UserId]		<> @User_ID

-- Please add appropriate Error Handling & Housekeeping

usp_Check_Username_Exit:

Return

usp_Check_Username_Err:

GOTO usp_Check_Username_Exit
GO

DECLARE @rc int
EXEC usp_Check_Username
       'X002548'					-- @Username				nvarchar (255)
      , null						-- @User_ID					bigint = 0
	  ,@rc OUTPUT
	  
SELECT @rc AS [RC]
GO

ALTER PROCEDURE [dbo].[Check_Username]
	-- Add the parameters for the stored procedure here
	@Username nvarchar (255) = '',
	@User_ID bigint = 0
AS
Declare @RC bigint = -1
EXECUTE @RC = Check_Username_Sub @Username, @User_ID  -- I renamed the original procedure Check_Username_Sub.
Select @RC as [RC]
return @RC

quote:

---

Originally posted by robvolk

Most of us like , you can add one using [beer] in your reply.

---