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 |
|
kellog1
Starting Member
35 Posts |
 Posted - 2010-08-07 : 22:42:11
|
| Here is sample data...RecordNumber PPSProjectNumber PPSRouteType PPSRouteNumber1 6664600107 M US 67 2 6664600107 K FAP 3103 6664600107 K FAP 3104 6664600107 K FAS 3103 0000700006 K FAP 1121 0000700006 M ILL 53 2 0000700006 S RUBY STDesired result is:1 6664600107 M US 671 0000700006 M ILL 53 2 0000700006 S RUBY STHow do I achieve this result? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-08 : 02:16:30
|
| didnt understand on what basis you determine records to be selected in output. can you explain?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Filter rows based on condition