Сделать, чтобы к каждому id принадлежала Фамилия работника

USE [Test]
GO
 
/****** Object:  Table [dbo].[TestTable]    Script Date: 22.03.2014 16:24:47 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
CREATE TABLE [dbo].[TestTable](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](50) NOT NULL,
    [IncomingTime] [datetime] NOT NULL,
    [LeaveTime] [datetime] NULL,
 CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
 
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE ToggleWorker 
    @id INT
AS
BEGIN
DECLARE @COUNT INT;
DECLARE @Name nvarchar(50);
WITH T AS
(SELECT top 1 [Id]
      ,[Name]
      ,[IncomingTime]
      ,[LeaveTime]
  FROM [dbo].[TestTable]
  WHERE id = @id
  ORDER BY [IncomingTime])
 
  SELECT @COUNT = COUNT(*),
        @Id = MAX(Id)
  FROM T
  WHERE [LeaveTime] IS NULL
 
  IF @COUNT = 0
    INSERT INTO [TestTable] ([Name], [IncomingTime])
    VALUES (@id, GETDATE())
  ELSE
    UPDATE [TestTable]
    SET [LeaveTime] = GETDATE()
    WHERE Name = @Name
END

SELECT fio FROM personal WHERE id = @id

SELECT 1 FROM personal WHERE idPersonal = :idPersonal

CREATE DATABASE TABEL
USE TABEL
CREATE TABLE Personal
(id INT NOT NULL PRIMARY KEY,
FIO VARCHAR(MAX) NOT NULL)
 
CREATE TABLE worktime
(idworktime INT NOT NULL PRIMARY KEY IDENTITY(1,1),
workdate datetime NULL,
incommingtime datetime NOT NULL,
leavetime datetime NULL,
id INT  NULL FOREIGN KEY REFERENCES Personal(id))