UFN_MKTSOURCECODEPARTDEFINITIONVALUES_NAMEISUNIQUE
Returns whether or not a name is unique among all part values for a given part definition.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(255) | IN | |
| @PARTDEFINITIONID | uniqueidentifier | IN | |
| @PARTDEFINITIONVALUESID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTSOURCECODEPARTDEFINITIONVALUES_NAMEISUNIQUE]
(
@NAME nvarchar(255),
@PARTDEFINITIONID uniqueidentifier,
@PARTDEFINITIONVALUESID uniqueidentifier
)
returns bit
as
begin
if isnull(@NAME,'') = ''
return 1;
return (
select case when exists(
select 1
from dbo.[MKTSOURCECODEPARTDEFINITIONVALUES]
inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID] = [MKTSOURCECODEPARTDEFINITION].[ID]
where [MKTSOURCECODEPARTDEFINITIONVALUES].[DESCRIPTION] = @NAME and [MKTSOURCECODEPARTDEFINITION].[ID] = @PARTDEFINITIONID and [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] <> @PARTDEFINITIONVALUESID)
then 0 else 1 end);
end