UFN_CONSTITUENT_GETCLASSYEAR_TVF
Find the Class Year for a given constituent
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_CONSTITUENT_GETCLASSYEAR_TVF](@CONSTITUENTID uniqueidentifier)
returns table
as
return
(
select
cast(CLASSOF as nvarchar(4)) as VALUE
from dbo.EDUCATIONALHISTORY with(nolock)
where CONSTITUENTID = @CONSTITUENTID
and ISPRIMARYRECORD = 1
and CLASSOF > 0
)