New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
SELECT LearnerRef, ROW_NUMBER() OVER(PARTITION BY LearnerRef ORDER BY LearnerRef ASC, GuidedLearnHours DESC), AimRef, GuidedLearnHours --INTO #TempStudentGLHTable FROM LearnerDataAimsTable WHERE AimRef NOT LIKE 'CMISC%' AND ActualEndDate IS NULL ORDER BY LearnerDataAimsTable.LearnerRef ASC, LearnerDataAimsTable.GuidedLearnHours DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.