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 |
|
C3000
Starting Member
3 Posts |
 Posted - 2007-12-10 : 23:02:19
|
| I have a table with all orders within 30 days of each other. Currently shows EVERY order placed within the next 30 days. Problem is that I only want to see the order that came RIGHT AFTER. Any suggestions?records currently show: order1,order2order1,order3order1,order4 order2,order3order2,order4order3,order4 would like to have:order1,order2order2,order3order3,order4 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-10 : 23:04:41
|
can you post your table DDL ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
query help - sequential order