Guys,
I'm trying to create a new field, entitled “Name” and see all employee names from my Employee table using the following format:
LastName, FirstName, jobcode, emailaddress and hire date.

after much effort my code is as follows:

CREATE VIEW 'Name'
AS
SELECT LastName, FirstName, JobID, Email, Hiredate AS Relationship
   FROM 'Name'
Create View 'Name' as Select LastName, FirstName, JobID, Email, Hiredate From EMPLOYEE
Group By LastName, FirstName, JobID, Email, Hiredate Order By LastName

But i'm still getting the following errors:

Msg 111, Level 15, State 1, Line 196
'CREATE VIEW' must be the first statement in a query batch.
Msg 102, Level 15, State 1, Line 199
Incorrect syntax near 'Name'.
Msg 111, Level 15, State 1, Line 200
'CREATE VIEW' must be the first statement in a query batch.

Any assistance is greatly appreciated

Update,, Realized i was duplicating my code.. Down to a single error now. I would imagine there is a routine to prevent the first query error??
Thanks..

Code:
CREATE VIEW Names
AS
SELECT LastName, FirstName, JobID, Email, Hiredate AS Relationship
   FROM Names
Group By LastName, FirstName, JobID, Email, Hiredate Order By LastName

Error:
Msg 111, Level 15, State 1, Line 196
'CREATE VIEW' must be the first statement in a query batch.

Hi,
Hopefully you have figured out your code by now, but if not, I would suggest renaming your view to something different than the table name such as Names_vw.
Good luck!