Viewing 2 posts - 1 through 2 (of 2 total)
Interesting article, as usual, but that class="code" style trashes the page, making it unreadable, please correct it! thanks
May 13, 2008 at 9:26 am
#814588
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,...
March 6, 2008 at 2:52 pm
#786372