Naomi,

What would I need to do to accomodate the Student ID from being null or the TutorID from being an empty string?
Thanks

>You're missing a closing ) in your code
>

>WHERE 
>		TutorID IN (SELECT Value from dbo.fnSplit(@TutorIDs, ',') -- here we need to add one more )
>

>
>I also don't like IN solution that much. I prefer using EXISTS operator.
>
>>>>Ah, well I didn't mean to. I just copy and pasted in and it worked. Thanks
>>>>Tim
>>>>
>>>You're welcome. I will be curious if you can compare 3 versions of the query: your original and 2 versions I posted and tell me the execution plans and percentage.
>>>
>>>Put all 3 queries (after a correction to your original) into one sql script and run them
>>>

>>>set nocount on
>>>set statistics io on
>>>set statistics time on
>>>query 1
>>>query 2
>>>query 3
>>>

>>>
>>>and post the results as well as percentage of execution time from the actual execution plan.
>>
>>
>>Hi Naomi,
>>
>>I doubt that would be useful as I only have test data plus this query pulls no more than a few records. I would be happy to do it however.
>>
>>Now I do have a problem with the query that uses the function. I have this error.
>>

>>Msg 156, Level 15, State 1, Procedure AppointmentsSelectByTutorsPlusStudentID, Line 19
>>Incorrect syntax near the keyword 'OR'.
>>

>>
>>With this SP
>>

>>CREATE PROCEDURE [dbo].[AppointmentsSelectByTutorsPlusStudentID]
>>(
>>	@TutorIDs varchar(500),
>>	@StudentID char(5)
>>)
>>AS
>>BEGIN
>>	SET NOCOUNT ON;
>>	
>>	SELECT 
>>		AppointmentID,
>>		TutorID,
>>		Description
>>	FROM [dbo].[Appointment]
>>	WHERE 
>>		TutorID IN (SELECT Value from dbo.fnSplit(@TutorIDs, ',') OR
>>		AppointmentID IN (SELECT AppointmentID FROM StudentAppointments WHERE StudentID = @StudentID) 
>>	
>>END
>>

>>Thanks
>>Tim