You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
383 B
18 lines
383 B
|
|
|
|
TRUNCATE TABLE Exam_Conclusion
|
|
SET IDENTITY_INSERT [dbo].[Exam_Conclusion] ON
|
|
|
|
INSERT INTO [dbo].[Exam_Conclusion]
|
|
([EID],[FID], [RID], [CID], [Conclusion], [Suggestion] , [Seq])
|
|
|
|
SELECT
|
|
[EnrollmentId] AS EID,
|
|
[FeeItemId] AS FID,
|
|
[ExamItemId] AS RID,
|
|
[ConclusionId] AS CID,
|
|
[Name] AS Conclusion,
|
|
[Suggestion] AS Suggestion ,
|
|
SORTNO AS SEQ
|
|
FROM PEIS.DBO.ExamConclusion
|
|
|