UFN_SPONSORSHIPAFFILIATE_GETNAME
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SPONSORSHIPAFFILIATE_GETNAME(@ID uniqueidentifier) returns nvarchar(100)
as
begin
declare @s nvarchar(50);
select @s = CO.NAME from dbo.SPONSORSHIPAFFILIATEPROGRAM SA inner join dbo.CONSTITUENT CO on CO.ID = SA.AFFILIATEID where SA.ID = @ID;
return @s;
end