tsql - 基于列值复制行的 SQL 方法

Question

我基本上需要将每一行与其他所有部门值重复，因此查看部门为其他的第一行，我需要复制第二行，部门名称为数学。可能有多个部门，所以我需要为每个潜在部门创建一个新行。有没有办法通过 SQL 做到这一点？

Select  743818 teacherPersonID, 'STUTZ, DOUGLAS' teacherDisplay, 'FT' personnelStatus, 1.0 ftePosition, 'Other' dept, 'INTRO TO COMPUTER SCIENCE, STUDENT ASST' course_name, 28 ttlStudents, 4 termSeq, 'course1' courseName, 'students1' courseStudents
Into    #teacherCourses
UNION 
Select  743818, 'STUTZ, DOUGLAS', 'FT', 1.0, 'Math', 'ALGEBRA 3, MATH 115 KSU COLLEGE ALGEBRA', 30, 4, 'course2', 'students2'
UNION 
Select  743818, 'STUTZ, DOUGLAS', 'FT', 1.0, 'Math', 'STUDENT ASST, ADVANCED GEOMETRY', 24, 4, 'course3', 'students3'
UNION 
Select  743818, 'STUTZ, DOUGLAS', 'FT', 1.0, 'Other', 'STUDENT ASST, ADVANCED GEOMETRY', 24, 4, 'course3', 'students3'
UNION 
Select  743818, 'STUTZ, DOUGLAS', 'FT', 1.0, 'Math', 'ADVANCED GEOMETRY', 25, 4, 'course4', 'students4'
UNION 
Select  743818, 'STUTZ, DOUGLAS', 'FT', 1.0, 'Math', 'MATH 115 KSU COLLEGE ALGEBRA, ALGEBRA 3', 21, 4, 'course6', 'students6'
UNION 
Select  743818, 'STUTZ, DOUGLAS', 'FT', 1.0, 'Math', 'ALGEBRA 3, MATH 115 KSU COLLEGE ALGEBRA', 19, 4, 'course7', 'students7'

标签： tsql