Problem :
I am facing following error with the below query in SQL Server 2012.
An expression of non-boolean type specified in a context where a condition is expected, near 'RETURN'.
SQL Query:
CREATE FUNCTION [dbo].[GetMYPMResources](@UserResourceNo nvarchar(250))
RETURNS @MyResources TABLE (
MyResourceNo nvarchar(250) COLLATE Latin1_General_CS_AS not null,
MyName nvarchar(250) COLLATE Latin1_General_CS_AS not null
)
AS
BEGIN
Declare @RoleID int, @UserDivision nvarchar(20)
SELECT TOP(1) @RoleID = r.ReportingRole, @UserDivision = r.DivisionCode
FROM Resource r
WHERE r.MyResourceNo = @UserResourceNo
INSERT @MyResources
SELECT r.MyResourceNo,MyName = r.MyResourceNo + ' ' + r.MyName
FROM Resource r WHERE r.MyResourceNo IN
(
SELECT m.MyResourceNo FROM JobMember m
JOIN Job j ON j.JobNo = m.JobNo
WHERE j.ProjectManagerNo = @UserResourceNo
OR
j.AlternateProjectManagerNo = @UserResourceNo
)
OR
(
SELECT m.MyResourceNo FROM JobMember m
JOIN JobTask t ON t.JobTaskNo = m.JobTaskNo
WHERE t.TaskManagerNo = @UserResourceNo
OR
t.AlternateTaskManagerNo = @UserResourceNo
)
RETURN
END