I have a table that I am using as a diary - there are 3 columns, ID(numeric),Subject(varchar) and date(datetime).
Is there any way that I can get SQL to select the Subject and then calculate how many day's it is until the date?
Subject Date Days Until Date
Xmas 25/12/2010 100 Days
View Complete Post