• Z.A.T (5/27/2010)


    I run solved this query then I answerd NULL, because you forget to write

    select @hourDiff

    in your query.

    so my answer is write NULL.

    if you wrote select @hourDiff at the last line then it will return 1.

    One might argue that the blame lies elsewhere, and the 'crime' committed was not reading the question properly.

    Attention to detail is often a desirable trait in DBAs...

    My other thought is that omitting the SELECT statement made it easier to get wrong for those people who just copy the code and execute it.