Return All Values in a Column as a Delimited List

USE AdventureWorks
GO

DECLARE @employeeIDs NVARCHAR(1000)
DECLARE @delimiter NVARCHAR(1)

        SET @employeeIDs = ''
        SET @delimiter = ';'

        SELECT @employeeIDs =
            COALESCE(
                    CASE WHEN @employeeIDs = ''
                        THEN CAST(EmployeeID AS NVARCHAR(5))
                        ELSE @employeeIDs + @delimiter + CAST(EmployeeID AS NVARCHAR(5))
                    END, '')
        FROM HumanResources.Employee

PRINT @employeeIDs