Hello all,

I just have a quick question on sql, something that I thought was strange but it does exist.

I need to create a table which contains a filed that needs to refer to some other record on the same table based on the unique id.

I.e

EmployeeID [primary key, identity]
Employee_Name
WeeklyHours
Salary
ManagerID (this column with need to refer to the employeeId field but can be null)

How should I proceed on creating the managerId field?

Thanks in advance,