UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS
Returns all letters and their corresponding selections for a given assign letters process.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASSIGNLETTERCODESPROCESSID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS
(
@ASSIGNLETTERCODESPROCESSID uniqueidentifier = null
)
returns @RESULT table
(
LETTERCODEID uniqueidentifier,
IDSETREGISTERID uniqueidentifier
)
as
begin
if @ASSIGNLETTERCODESPROCESSID is null
insert into @RESULT(LETTERCODEID,IDSETREGISTERID)
select
LETTERCODE.ID,
IDSETREGISTER.ID
from
dbo.LETTERCODE
inner join
dbo.IDSETREGISTER on LETTERCODE.IDSETREGISTERID = IDSETREGISTER.ID
where
LETTERCODE.ISACTIVE = 1
and LETTERCODE.IDSETREGISTERID is not null;
else
insert into @RESULT(LETTERCODEID,IDSETREGISTERID)
select
ASSIGNLETTERCODESPROCESSLETTERCODES.LETTERCODEID,
IDSETREGISTER.ID
from
dbo.ASSIGNLETTERCODESPROCESSLETTERCODES
inner join
dbo.LETTERCODE on ASSIGNLETTERCODESPROCESSLETTERCODES.LETTERCODEID = LETTERCODE.ID
inner join
dbo.IDSETREGISTER on LETTERCODE.IDSETREGISTERID = IDSETREGISTER.ID
where
ASSIGNLETTERCODESPROCESSID = @ASSIGNLETTERCODESPROCESSID
and LETTERCODE.ISACTIVE = 1
and LETTERCODE.IDSETREGISTERID is not null;
return;
end