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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: blueparaiba
- Order by date
-
Find the MAX(Date) and then find the next date <=MAX(Date)
Hi I am trying to find the MAX(Date) in a table and then calculate the results from that row and then find the date that is equal or less than that date and calculate the results of that field. For example: Ref Date Qty 6 29/09/01 2 6 02/08/01 3 6 01/07/02 1 23 28/09/01...- blueparaiba
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Best way to write this query
I have tried this query, but I am returning 24 rows and not 6 rows. Can you suggest a improvement, please. SELECT t.NodeType , t.Reference , t.GID , t.Date , t.Quantity , m.Price1 , t.Quantity*m.Price1 FROM ( SELECT NodeType , Reference...- blueparaiba
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Best way to write this query
GID Node Ref Item Date Qty 0 32320 6 0 2008-11-01 00:00:00.000 8 0 32320 6 1 2009-03-01 00:00:00.000 10 0 32320 6 2 2009-05-01 00:00:00.000 6 0 32320 6 3 2009-12-01 00:00:00.000 6 0 32320 6 4 2010-06-01 00:00:00.000 6 0 32320 6 5...- blueparaiba
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
