/* 
CREATE TABLE [tbl_uniqe_id] (
	[ID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[ClientID] [bigint] NOT NULL ,
	CONSTRAINT [PK_tbl_uniqe_id] PRIMARY KEY CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
*/

CREATE PROC pr_getUID
	@ClientID	bigint
AS
BEGIN
	DECLARE @uID		bigint,
		@erCode		int

	SET NOCOUNT ON
	INSERT tbl_uniqe_id (ClientID) VALUES (@ClientID)
	SELECT @erCode = @@error, @uID = @@identity
	IF @erCode <> 0
	BEGIN
		RAISERROR('Unable to get new id:', 16, 1)
		RETURN @erCode
	END

	RETURN @uID
END