Stored Procedure / Recursion / Sql Server 2005

Hello my friends

This is my sql table structure

FK = ID int,
Empnaam varchar(200),
PK = EmpID int

With this table, where i insert values, employees can hire other employees. Now i want to see with a function in visual studio who hired who. I get stuck when a person hired more than 1 person....
This is my stored procedure :


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[ShowHierarchy]
(
@Root int
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @EmpID int, @EmpNaam varchar(30)

SET @EmpNaam = (SELECT EmpNaam FROM dbo.Emp WHERE EmpID = @Root)
PRINT REPLICATE('-', @@NESTLEVEL * 4) + @EmpNaam

SET @EmpID = (SELECT MIN(EmpID) FROM dbo.Emp WHERE ID = @Root)

WHILE @EmpID IS NOT NULL BEGIN
EXEC dbo.ShowHierarchy @EmpID
SET @EmpID = (SELECT MIN(EmpID) FROM dbo.Emp WHERE ID = @Root AND EmpID > @EmpID)
END
END

Thanks in advance!
Grtz