ALTER PROCEDURE dbo.BookingData
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
		@VisitID varchar, 
		@PatientID varchar
AS
	/* SET NOCOUNT ON */

	RETURN
	DEclare @isEmp as varchar
	set @isEmp = ISNULL(@VisitID,0)
	IF @isEmp = 0
		begin
		SELECT Visits.VisitID, Visits.PatientID, Visits.DateBooked, Visits.TimeBooked, Visits.ReasonForVisit
                                              , Visits.DoctorID, Visits.DoctorsComments, Visits.FollowUpDate, Visits.Cost, Visits.VisitTypeID
                                              , VisitTypes.VisitType, Doctors.FirstName + ' ' + Doctors.LastName AS DoctorsName
                                       FROM   VisitTypes INNER JOIN Visits ON VisitTypes.VisitTypeID = Visits.VisitTypeID INNER JOIN
                                              Doctors ON Visits.DoctorID = Doctors.DoctorID WHERE Visits.PatientID = @PatientID  ORDER BY VisitID DESC;
		end 
ELSE
	SELECT Visits.VisitID, Visits.PatientID, Visits.DateBooked, Visits.TimeBooked, Visits.ReasonForVisit
                                              , Visits.DoctorID, Visits.DoctorsComments, Visits.FollowUpDate, Visits.Cost, Visits.VisitTypeID
                                              , VisitTypes.VisitType, Doctors.FirstName + ' ' + Doctors.LastName AS DoctorsName
                                       FROM   VisitTypes INNER JOIN Visits ON VisitTypes.VisitTypeID = Visits.VisitTypeID INNER JOIN
                                              Doctors ON Visits.DoctorID = Doctors.DoctorID WHERE Visits.PatientID = @PatientID AND Visits.VisitID =@VisitID ORDER BY VisitID DESC;