In sql i have employee master table.
Select empname,empid, empdeparment
from tblemployeemaster
How can i add one more columns without creating an static column in table with 4 hardcode values is an script how to bind this employee master.
SELECT *
FROM (VALUES('Client '),('Stakeholders'),
('Peers'),('E-Mail ')
) AS sub(Reviewer)