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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I create a query that does a range lookup?
Thanks, you got me on the right track. I ended up with the following: ( select A1.item_key, A1.trans_date, MAX(A1.effective_date) Effective_date from ( select price.item_key, trans.trans_date, price.effective_date, from price, trans where...- lleach9
- Post #6
- Forum: Microsoft SQL Server: Programming
-
How can I create a query that does a range lookup?
Thanks, you got me on the right track. I ended up with the following: ( select A1.item_key, A1.trans_date, MAX(A1.effective_date) Effective_date from ( select price.item_key, trans.trans_date, price.effective_date, from price, trans where...- lleach9
- Post #5
- Forum: Microsoft SQL Server: Programming
-
How can I create a query that does a range lookup?
It is a little more complicated than that. In the case of a price table with 4 prices for each item, with a different effective date for each price, your suggestion would return 4 rows for each transaction. I am trying to narrow the result down to one row for each transaction, showing the...- lleach9
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How can I create a query that does a range lookup?
I have two tables, one that contains an item key, an effective date, and a price and a second table that contains an item key and a transaction date. I would like to create a query that would join the tables to show item key transaction date price (where the effective date is less than the...- lleach9
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
