PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
select STUDENT_NUMBER as "StuNum", max(CMTSCIENCE) AS "Grade 8 CMT Science", max(SATTOTAL) AS "Grade 8 CMT Science" FROM ( select students.student_number AS STUDENT_NUMBER, CASE WHEN UPPER(Test.Name) = 'CMT' AND StudentTest.GRADE_LEVEL = '8' AND TestScore.NAME = 'Science Scale Score' THEN StudentTestScore.numscore ELSE NULL END AS CMTSCIENCE,--"Grade 8 CMT Science" CASE WHEN UPPER(Test.Name) = 'SAT' AND TestScore.NAME = 'Total Score' THEN StudentTestScore.numscore ELSE NULL END AS SATTOTAL,--"Latest SAT Total" StudentTest.TEST_DATE from students LEFT JOIN StudentTestScore ON StudentTestScore.StudentID = Students.ID LEFT JOIN StudentTest ON StudentTestScore.StudentTestID = StudentTest.ID LEFT JOIN Test ON StudentTest.TestID = Test.ID LEFT JOIN TestScore ON StudentTestScore.TestScoreID = TestScore.ID WHERE StudentTestScore.NumScore > 0 AND Students.STUDENT_NUMBER IN ('3023484','3010864') ) WHERE CMTSCIENCE > 0 OR SATTOTAL > 0 group by STUDENT_NUMBER order by STUDENT_NUMBER
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Force XMLSEQUENCE to return empty tags for null values.||10||47|
|Generate list for insert to sql list||46||21|
|VB.net SQL Count working days between two days||4||22|
Join the community of 500,000 technology professionals and ask your questions.