/*******Inserts for Doctorpatient
keziah koigi***********/

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
           VALUES (1,1000,'7/6/2006')
     

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
           VALUES(2,1003,'5/6/2007')

  INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
           VALUES(3,1006,'2/6/2007')
  
INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
           VALUES(4,1009,'2/6/2008')     
 
  INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
           VALUES(5,1012,'1/4/2008')     

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(1,1015,'4/4/2008')

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(2,1018,'4/1/2006')

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(3,1021,'2/6/2008')

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(4,1024,'12/9/2008')

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(5,1027,'11/4/2008')

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(1,1030,'9/3/2006')

INSERT INTO [ClinicalDrugStudy].[dbo].[Doctorpatient]
           ([DoctorID]
           ,[PatientID]
           ,[drpassigndate])
            VALUES(1,1033,'2/9/2008')