Untitled

Error message in INSERT Statement

INSERT into AppointmentDetails (SelectedApptDate, SelectedApptStartTime,

                                SelectedApptEndTime, SelectedWeddingPlanner)

   SELECT

       ApptID

   from

       Appointment

   INNER JOIN

       Appointment ON Appointment.ApptID = AppointmentDetails.ApptID

   WHERE

       SelectedApptDate = @SelectedApptDate,

       SelectedApptStartTime = @SelectedApptStartTime,

       SelectedApptEndTime = @SelectedApptEndTime,

       SelectedWeddingPlanner = @SelectedWeddingPlanner

       

command.CommandText = "INSERT into AppointmentDetails (SelectedApptDate, SelectedApptStartTime, SelectedApptEndTime, SelectedWeddingPlanner) SELECT ApptID from Appointment INNER JOIN Appointment ON Appointment.ApptID = AppointmentDetails.ApptID WHERE SelectedApptDate = @SelectedApptDate, SelectedApptStartTime = @SelectedApptStartTime, SelectedApptEndTime = @SelectedApptEndTime, SelectedWeddingPlanner = @SelectedWeddingPlanner";

 

    command.Connection = connection;

    command.Parameters.AddWithValue("@SelectedApptDate", dateSelected);

    command.Parameters.AddWithValue("@SelectedApptStartTime", timeStart);

    command.Parameters.AddWithValue("@SelectedApptEndTime", timeEnd);

    command.Parameters.AddWithValue("@SelectedWeddingPlanner", weddingplanner);

       

INSERT into AppointmentDetails (SelectedApptDate, SelectedApptStartTime,

           SelectedApptEndTime, SelectedWeddingPlanner)

SELECT ApptID

from Appointment

INNER JOIN Appointment ON Appointment.ApptID = AppointmentDetails.ApptID

WHERE SelectedApptDate = @SelectedApptDate

   AND  SelectedApptStartTime = @SelectedApptStartTime

AND SelectedApptEndTime = @SelectedApptEndTime

AND  SelectedWeddingPlanner = @SelectedWeddingPlanner";

       

command.CommandText = "INSERT into AppointmentDetails (SelectedApptDate,  

                                                       SelectedApptStartTime,  

                                                       SelectedApptEndTime,  

                                                       SelectedWeddingPlanner)

 

SELECT ApptID from Appointment

INNER JOIN Appointment ON Appointment.ApptID = AppointmentDetails.ApptID

WHERE  SelectedApptDate = @SelectedApptDate

AND SelectedApptStartTime = @SelectedApptStartTime

AND SelectedApptEndTime = @SelectedApptEndTime

AND SelectedWeddingPlanner = @SelectedWeddingPlanner";