title: Calculating Date ranges in T-SQL
body: <p>I have a date field that I would like to results returned where the date is minus a given amount of days.  For example, WHERE @today - 30 would give me the last 30 days of data.  How can I do this?</p>