UFN_BBNCUSERMAP_GETBBNCUSERID
Get BBNC User ID with given app user
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BBNCUSERMAP_GETBBNCUSERID(@APPUSERID uniqueidentifier)
returns int
with execute as caller
as begin
declare @ClientUserId int
select @ClientUserId=cu.ID from dbo.BBNCUSERMAP map
join dbo.ClientUsers cu on cu.UserName=map.BBNCUSERNAME
where map.ID=@APPUSERID
return @ClientUserId
end