UFN_PROSPECTID_MAPFROM_PROSPECTPLANID
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROSPECTPLANID | uniqueidentifier | IN |
Definition
Copy
create function BBDW.[UFN_PROSPECTID_MAPFROM_PROSPECTPLANID](@PROSPECTPLANID uniqueidentifier)
returns [uniqueidentifier]
as
begin
declare @ID [uniqueidentifier];
select
@ID = [CONSTITUENTSYSTEMID]
from BBDW.[DIM_PROSPECTPLAN]
where [PROSPECTPLANSYSTEMID] = @PROSPECTPLANID;
return @ID;
end