Msg 102, Level 15, State 1, Line 9

• jbolton42

  SSC Enthusiast

  Points: 104

  More actions

  May 12, 2008 at 9:02 pm

  #190421

  Hi All:

  I have an error message that i cannot figure out, it is Msg 102, Level 15, State 1, Line 9

  Incorrect syntax near 'Workers'. I am attempting to increase the salary for Sales Workers by 5%. I have been working on this query for over twelve hours and I feel like throwing a brick (sponge of course) at my computer. Any help is greatly appreciated.:D

  My code is as follows:

  USE Kudler

  SELECT *

  FROM Employee, JobTitle

  SELECT e.Salary, e.EEO1Classification

  WHERE e.EEO1Classification = (SELECT Sales Workers

  FROM Employee.e

  WHERE e.EEO1Classification = Sales Workers)

  ORDER by Salary

  FROM Employee.e

  UPDATE Employee

  SET Salary = Salary & 1.05

  GO

• jbolton42

  SSC Enthusiast

  Points: 104

  More actions

  May 12, 2008 at 10:06 pm

  #814215

  Hi:

  I figured it out. My correct code as follows:

  USE Kudler

  SELECT *

  FROM Employee, JobTitle

  SELECT Salary, Employee.EEO1Classification

  FROM Employee

  WHERE EEO1Classification = 'Office/Clerical';

  UPDATE Employee

  SET Salary = Salary * 1.05

  GO

  Thanks,

  Jen