Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Fun with Outer Joins

    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...

  • RE: Fun with Outer Joins

    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

    ...

  • RE: TSQL function to detect SQL Agent job state

    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...

Viewing 3 posts - 1 through 3 (of 3 total)