I'm aware of how infuriating it can be when you find someone experiencing the same difficulty as yourself only to find that they never posted the outcome or solution in...

For anybody that's interested, I solved the problem by creating a UDF as suggested, like so;

CREATE FUNCTION udf_ARS_ReturnLecturers
(
@RegisterID int
)

RETURNS nvarchar (1000)

AS

BEGIN
DECLARE @Lecturers...

Close, the output I'm after hasn't come out too great on screen. I want to concatenate all the prs_name fields into one field called Lecturers. I'll do it...