SQL - sp to have one line query with semi colon seperated

-- If stored procedure named dbo.GetTargetUserForPrivateSurvey already exists in the database

IF EXISTS ( SELECT * FROM sysobjects WITH(NOLOCK)

            WHERE id = OBJECT_ID('dbo.GetTargetUserForPrivateSurvey')

            )

BEGIN

      -- Drop the stored procedure  

    DROP PROCEDURE dbo.GetTargetUserForPrivateSurvey

END

GO

-- ********************************************************

-- ** FileName: GetTargetUserForPrivateSurvey.sql

-- ** Procedure Name: dbo.GetTargetUserForPrivateSurvey '30'

-- ** Description:

-- ** Author: ACUVATE\Princy

-- ** Created Date: June 22 2009

-- ---------------------- Modification Log ---------------

-- ** Date           Author        Modification

-- -------------------------------------------------------

-- **

-- ********************************************************

CREATE PROCEDURE [dbo].[GetTargetUserForPrivateSurvey]

( @SurveyId NUMERIC(18,0)

)

AS

BEGIN

      DECLARE @Emails NVARCHAR(MAX)

      SET @Emails = ''

      SELECT @Emails =@Emails+';'+ AU.UserName

      FROM dbo.SurveyTargets ST

            INNER JOIN dbo.aspnet_UsersInRoles AUR

            ON ST.RoleId = AUR.RoleId

            AND ST.IsActiveInd = 1

            INNER JOIN dbo.aspnet_Users AU

            ON AU.UserId = AUR.UserId

      WHERE ST.SurveyId = @SurveyId

      SELECT SUBSTRING(@Emails,2,LEN(@Emails))

END