1
Include only most recent entry in report
What selection criteria would limit the display to only the most recent entry per account?
Answer Question
| October 15, 2012 5:44 PM
Crystal Reports 11, Selection Criteria
What selection criteria would limit the display to only the most recent entry per account?
Answer Question
| October 15, 2012 5:44 PM
Crystal Reports 11, Selection Criteria
Date Time SQL Selection Criteria
Hi everyone, My database table has a time field called [time], Data Type of “Numeric” length of “9″ with a Precision of “14″ a Scale of “0″. The query below produces the following output : 2009-10-14 00:02:42.000 2009-10-28 20:15:10.000 Query : select DATEADD(ss,CAST(Left(min(time),10) AS INT),’01/01/1970′),DATEADD(ss,CAST(Left(max(time),10) AS INT),’01/01/1970′) from tblTest Which is fine it has given [...]
Answer Question
| November 3, 2009 2:22 PM
Date Time, Selection Criteria, SQL Server, T/SQL
Hi everyone, My database table has a time field called [time], Data Type of “Numeric” length of “9″ with a Precision of “14″ a Scale of “0″. The query below produces the following output : 2009-10-14 00:02:42.000 2009-10-28 20:15:10.000 Query : select DATEADD(ss,CAST(Left(min(time),10) AS INT),’01/01/1970′),DATEADD(ss,CAST(Left(max(time),10) AS INT),’01/01/1970′) from tblTest Which is fine it has given [...]
Answer Question
| November 3, 2009 2:22 PM
Date Time, Selection Criteria, SQL Server, T/SQL
1
