Forum Replies Created

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

  • RE: PIVOT working incorrectly?

    Interesting article, as usual, but that class="code" style trashes the page, making it unreadable, please correct it! thanks

  • RE: Best Way to Calculate Age

    The last part of the third query must be THEN 1 ELSE 0 in order to work properly:

    declare @DateOfBirth datetime

    set @DateOfBirth = '31/07/1960'

    select DATEDIFF(yy, @DateOfBirth, GETDATE())

    select FLOOR(CONVERT(decimal(9, 2), DATEDIFF(d,...

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