Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-09-25 : 19:03:01
|
| Hey guys,my apologies if this is basic but, I am tired and just need a refresh.I have a basic statementSet @mydate = (select Max(notedate) from CaseNote where caseid = @cid AND staffid = @staff AND (DateDiff(dd,notedate,getDate()) > 30))this returns the first notedate that is > 30 days from today (near as I can tell).I want to only grab a notedate and put it into the var if the most recent notedate is > 30 days from now.appreciate the insight.Edited by - vivaldi on 09/25/2001 19:24:47 |
|
|
|
|
|
tired, long week, simple question