UFN_ID_MAPFROM_WPWHOSWHOID

Maps a WPWHOSWHOID to a ID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@WPWHOSWHOID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_ID_MAPFROM_WPWHOSWHOID(@WPWHOSWHOID uniqueidentifier) 
            returns uniqueidentifier
            as begin
                declare @ID uniqueidentifier;

                select @ID = WEALTH.ID from dbo.WPWHOSWHO
                inner join dbo.WEALTH on WEALTH.ID = WPWHOSWHO.WEALTHID
                where WPWHOSWHO.ID = @WPWHOSWHOID;

                return @ID;
            end