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 |
|
common
Starting Member
1 Post |
Posted - 2005-12-23 : 11:02:52
|
| Example DATA:DecisionFK TrapReasonDesc ----------- --------------------------------------------------------------------------- 2848 Unqualified Invalid SSN2850 SSN Dupe2855 SSN Dupe2867 Unqualified Income3010 Unqualified Income3043 Unqualified Invalid SSN3043 Unqualified Non-US ResidentThe output i would like to return is3043, Unqualified Invalid SSN + Unqualified Non-US ResidentI do not want to use cursors. So is there a way to select from a table like above and output the results 1 after the other, like my desired output? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
|
|
|