You can't alias the "*"

You need a comma after the star, like so: DECLARE @Employee TABLE (FullName varchar(10), Salary money)

INSERT INTO @Employee

SELECT 'John Doe', 85000 UNION ALL

SELECT 'Jane Doe', 87244 UNION ALL

SELECT 'John Doe', 77854 UNION ALL

SELECT 'John Doe', 94875

SELECT

*, ROUND( (Salary * .1), 2) AS Raise

FROM @Employee You should always write out the columns names wherever possible and refrain from using "*" when possible.

Ex:DECLARE @Employee TABLE (FullName varchar(50), Salary money)

INSERT INTO @Employee

SELECT 'John Doe', 85000 UNION ALL

SELECT 'Jane Doe', 87244 UNION ALL

SELECT 'Tim McGraw', 77854 UNION ALL

SELECT 'Arnold Stumph', 94875

SELECT

FullName [LuckyBa$tard], Salary, ROUND( (Salary * .1), 2) AS Raise

FROM @Employee