Viewing 3 posts - 1 through 3 (of 3 total)
Oh I understand what the author is doing and it's a good article.
But when it takes a less time, is probably more efficient and in my opinion is easier to...
January 20, 2014 at 5:18 am
Surely the following is an easier way to accomplish this...
SELECT PR.id, PR.ProfessorName, ClassName, ClassYear, ClassSemester
FROM Professor PR
LEFT JOIN
(
SELECT ProfessorID, ClassName, ClassYear, ClassSemester
FROM Class
WHERE ClassYear>=2011
...
January 20, 2014 at 3:49 am
wouldn't it be easier just to set the value of a Field when the 1st job is running...then your 2nd job could just read the value and run/not run depending...
February 8, 2012 at 2:52 am
Viewing 3 posts - 1 through 3 (of 3 total)