USP_IDMAPPER_FAFBBNCPAGECONTEXT

create procedure dbo.USP_IDMAPPER_FAFBBNCPAGECONTEXT
(
    @SOURCEID varchar(250),
    @TARGETID uniqueidentifier output
)
as
    set nocount on;

  declare @item varchar(50)

  select @item = item from dbo.UFN_STRING_PARSER('&', @SOURCEID) where item like '%crg=%'

  set @item = RTrim(LTrim(@item))

  set @TARGETID = cast(substring(@item, CHARINDEX( '=',@item, 0) + 1 , len(@item)) as uniqueidentifier)

    return 0;