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 |
|
musman
Starting Member
17 Posts |
 Posted - 2010-05-27 : 16:35:01
|
| hi,there is situation when I insert a row with updated status and want to select that row for that Client and the rows that have not been updated for other clients. So dataset should a union of updated (for client A) and non-updated(for clients other than A). how would I do that.For exampleColumn0 Column1 Column2 Status Column4 Column50 1 abc 'A' efg hij1 1 abc 'U' klm hij2 2 ook 'A' oko dddResult Set I want is Column0(1) and Column0(2 )Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-27 : 16:58:38
|
hi,there is situation when I insert a row with updated status and want to select that row for that Client and the rows that have not been updated for other clients. So dataset should a union of updated (for client A) and non-updated(for clients other than A). how would I do that.For exampleColumn0 Column1 Column2 Status Column4 Column50 1 abc 'A' efg hij1 1 abc 'U' klm hij2 2 ook 'A' oko ddd Result Set I want is Column0(1) and Column0(2 )ThanksSorry but also with a better formatted post I can't see any sense in this.How will you go on and give ONE recordset to different clients with different needs?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
How to Select different rows different criteria