INSERT Result(StudentNo,SubjectId,StudentResult,ExamDate)
SELECT 'S1201302001',1,80,'2013-9-13' UNION
SELECT 'S1201302002',1,45,'2013-9-13' UNION
SELECT 'S1201302001',2,90,'2013-10-18' UNION
SELECT 'S1201302002',2,60,'2013-10-18'
INSERT Result(StudentNo,SubjectId,StudentResult,ExamDate)
SELECT 'S1201302001',1,80,'2013-9-13' UNION
SELECT 'S1201302002',1,45,'2013-9-13' UNION
SELECT 'S1201302001',2,90,'2013-10-18' UNION
SELECT 'S1201302002',2,60,'2013-10-18'