Coalesce

select StatusDes

from tblstatusmaster

DECLARE @DepartmentName VARCHAR(1000)

SELECT @DepartmentName = COALESCE(@DepartmentName,'') + StatusDes + ';' 
FROM  tblstatusmaster

SELECT @DepartmentName AS DepartmentNames

StatusDes

Scheduled

Registered

Scan Completed

Report Completed

In Progress

Report Despatched

DepartmentNames

Scheduled;Registered;Scan Completed;Report Completed;In Progress;Report Despatched;