Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with unique rows
Hi, Apologies! I did the following (my simple example was so that I didn't have to write loads of columns, etc...). select customer_id, {all other fields}, max(valid_from) from ( select customer_id, {all other fields}, valid_from from table where ( all exclusions, etc ) ) group by... -
vbCrLf in C#
Hi, I had some trouble using this with the String.Append function. Somebody told me about the Environment.Newline constant in the System.Environment collection. Maybe useful? Maybe not...... Dom- DomCotton
- Post #3
- Forum: C# (C sharp): Microsoft
-
Help with unique rows
Hi, Thanks for the help. I had tried using a subquery - the problem was the resultset was way to slow. I have now managed it using something similar to carp's pointers. Thanks for the help. Dom -
Help with unique rows
Hi, I am trying to construct a view in an Oracle database. I have a select statement that returns something like below: CUSTOMER_ID VALID_FROM 100 08/02/2004 00:01:11 100 08/02/2004 00:02:11 100 08/02/2004 00:03:11...
