I have to admit that I didn't understand much of Lutz solution (but I did copy the suggestion into the Management Studio, and the result was exactly as I wanted...

Ok, I'll give it a new try, WITH the tables and some sample data.

CREATE TABLE #Patient

(

PatientID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

LastName NVARCHAR(40),

FirstName NVARCHAR(40)

)

CREATE TABLE #Followup

(

FollowupID INT IDENTITY,

PatientID INT,

FollowupDate DATETIME

)

INSERT INTO...

Sorry, my workstation I has SQL 2008 express installed, but the server is SQL 2000 (I'm not testing against real data).

Thank you. I don't fully understand what's happening, but when I run the query it creates one column for all followups, and I need one column for each followup...