Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE TABLE #MyTable ( ID INT, Name VARCHAR(200), Courses VARCHAR(200) )
Insert Into #MyTable (ID, Name) Select ID, Name From Student
SELECT ID, CourseID, CourseName INTO #CourseTable FROM Courses c INNER JOIN xferNameCourse xnc ON c.CourseID = xnc.CourseID WHERE nc.ID IN ( SELECT ID FROM #MyTable ) UPDATE mt SET mt.CourseName = s.CourseName FROM #MyTable mt INNER JOIN #Courses c ON mt.ID = c.ID
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.