--Create temp table with staff members to email
Declare @Table Table (CentreID int
                        , PrimaryEmailAddress varchar(200)
                        , ReceiveEmails bit
                        , ReceiveSAE bit
                        , ReceiveRandomisationBlinded bit
                        , ReceiveRandomisationUnblinded bit
                        , ReceiveHTAssignment bit
                        , ReceiveRandomisationControl bit
                        , ReceiveRandomisationIntervention bit
                        )

Insert @Table Exec Staff.sp_StaffMembersToEmail @CentreId = 1

Select * From @Table

--COALESCE function to retrieve email addresses from @Table
Declare     @EmailAddressesCoalesce Varchar(1000)

Select      @EmailAddressesCoalesce = Coalesce(@EmailAddressesCoalesce, '') + PrimaryEmailAddress + ', '
From        @Table

Select @EmailAddressesCoalesce as EmailAddressesCoalesce


--CURSOR function to retrieve email addresses from @Table
Declare @EmailAddressesCursor varchar(1000)
Declare email_cursor cursor for
Select PrimaryEmailAddress
From @Table

Declare @NextEmail varchar(200)
Set @EmailAddressesCursor = ''

Open email_cursor
Fetch next from email_cursor into @NextEmail
While @@FETCH_STATUS = 0
Begin
        Set @EmailAddressesCursor += @NextEmail + ', '
        Fetch next from email_cursor into @NextEmail

End

Close email_cursor

Select @EmailAddressesCursor As EmailAddressesCursor