USP_GETPREFERENCEOPTIONBYGROUPID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PREFERENCEGROUPID | nvarchar(50) | IN |
Definition
Copy
CREATE PROCEDURE dbo.USP_GETPREFERENCEOPTIONBYGROUPID
(
@PREFERENCEGROUPID as nvarchar(50)
)
as
begin
select
ID as OptionID,
NAME as OptionName
from dbo.EVENTPREFERENCE
where EVENTPREFERENCEGROUPID = @PREFERENCEGROUPID
order by SEQUENCE asc
end