An expression of non-boolean type specified in a context where a condition is expected

Question

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

Answer 1

Your problem might be following query snippet:

OR

(

SELECT m.MyResourceNo FROM JobMember m

JOIN JobTask t ON t.JobTaskNo = m.JobTaskNo

WHERE t.TaskManagerNo = @UserResourceNo

OR

t.AlternateTaskManagerNo = @UserResourceNo

)

try updating it to as below

OR r.MyResourceNo IN

(

SELECT m.MyResourceNo FROM JobMember m

JOIN JobTask t ON t.JobTaskNo = m.JobTaskNo

WHERE t.TaskManagerNo = @UserResourceNo

OR

t.AlternateTaskManagerNo = @UserResourceNo

)