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 |
|
mahimam_2004
Starting Member
40 Posts |
 Posted - 2007-01-24 : 12:02:30
|
| Hi, I have a table ExRoute:Columns RouteID caseno70 87671 87771 876 now my qery need to be return route count70 1 --(876)71 2 --(877,876)70/71 1 --(876 has both routes 70 and 71) how to write query.Thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-24 : 12:23:33
|
| There can be an unlimited number for routes for a caseno...Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Query