UFN_COURSE_GETGRADELEVELSTRING
Returns the student grade levels allowed for a course.
Return
| Return Type |
|---|
| nvarchar(1000) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COURSEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_COURSE_GETGRADELEVELSTRING
(
@COURSEID uniqueidentifier
)
returns nvarchar(1000)
with execute as caller
as begin
declare @GRADELEVELLIST nvarchar(1000)
select
@GRADELEVELLIST = coalesce(@GRADELEVELLIST + '; ', '') + GRADELEVEL.ABBREVIATION
from dbo.COURSEGRADELEVEL
inner join dbo.SCHOOLGRADELEVEL on COURSEGRADELEVEL.SCHOOLGRADELEVELID = SCHOOLGRADELEVEL.ID
inner join dbo.GRADELEVEL on SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
where dbo.COURSEGRADELEVEL.COURSEID = @COURSEID
order by dbo.GRADELEVEL.SEQUENCE
return @GRADELEVELLIST
end