Is this horrible?

gistfile1.txt

IF OBJECT_ID('[dbo].spGetParticipantReportOptionsByProgram', 'P') IS NOT NULL
    BEGIN
        DROP PROCEDURE [dbo].[spGetParticipantReportOptionsByProgram];
    END;

go

CREATE PROCEDURE [dbo].[spGetParticipantReportOptionsByProgram] @inProgramId INT
AS

SELECT DISTINCT 'RegionCode' AS k, RegionCode AS v FROM Employee WHERE ProgramId = @inProgramId
UNION
SELECT DISTINCT 'JobFunctionCode' AS k, JobFunctionCode AS v FROM Employee WHERE ProgramId = @inProgramId
UNION
SELECT DISTINCT 'JobFunctionName' AS k, JobFunctionName AS v FROM Employee WHERE ProgramId = @inProgramId
UNION
SELECT DISTINCT 'CompanyCode' AS k, CompanyCode AS v FROM Employee WHERE ProgramId = @inProgramId
UNION
SELECT DISTINCT 'CompanyCodeName' AS k, CompanyCodeName AS v FROM Employee WHERE ProgramId = @inProgramId
UNION
SELECT DISTINCT 'CostCenter' AS k, CostCenter AS v FROM Employee WHERE ProgramId = @inProgramId
UNION
SELECT DISTINCT 'CostCenterDescription' AS k, CostCenterDescription AS v FROM Employee WHERE ProgramId = @inProgramId
;
go
--command to test out
--exec spReportAwardGetServiceAwardsByProgram @inProgramId = 255, @inReportDateStart = '12-21-16',
--@inReportDateEnd = '12-21-19'