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 |
|
mu
Starting Member
1 Post |
 Posted - 2011-08-20 : 18:50:31
|
| hiI want to count many of a custom field are returned in the search results from the calendar week before.{field51} = the field I am working with and is a date field.Formula so far isCASE WHEN ({field51}-(CASE WHEN nvl({today},{field51}-1) > nvl({field51},{today}-1) THEN {today} ELSe {field51} END)) < 7 THEN 1 ELSE 0 END I want to count the search results for field51 were returned for the date value of the last calendar week. Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-21 : 00:29:44
|
| are you using ORACLE? this is a ms sql server forum and solutions given are mostly sql server specific. so please try your luck at www.orafaq.com------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
sql count help