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 |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2010-08-08 : 03:55:49
|
hi this is what i want to achive."Today's date minus Next Delinquency Date is > 60 days" the next delinquency date have three dates 30, 60, 90 from create date. if i pass to 30 days i need to get the 60 date.and my code wrote like this.select * from table where datediff(day, getdate(), (select min(Nextdelinquencydt) from table)) > 60 Is this correct? or there are any simplier code that can achive this? |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-08 : 07:30:27
|
| how do you have data stored in the table? it's hard to tell if query is correct if one does not know the structure of your table and data.otherwise query will go through the parser okey, but the question is if the retrieved results are ok? :) |
 |
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-08-09 : 01:17:46
|
| give some examples in the table such as data typesWith RegardsKashyap M |
|
|
|
|
|
|
date diff verification