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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-25 : 22:08:02
|
| Ray writes "I have a table that contains 2 fields that contain dates. I need to use this table to entires in another table by records in the first table that have date values between the date ranges in the first table. Their is no common key between the 2 tables. The reason for grouping them together by date range is to count the number of specific values in a column of the second table. I have spent countless hours trying to solve this problem. Win NT 4.0 SQL 7. The last requirement in my problem is to use as much standard SQL as possible to allow this to be portable." |
|
|
|
|
|
Grouping by date range