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 |
|
Yame
Starting Member
1 Post |
 Posted - 2011-01-21 : 06:26:46
|
| We have the records in one of the row as follows : AB CD AB EF CD ABWe have used With XML function in sql queryWe want to select only unique records from particular record set which is getting from WITH XML query like AB CD EFHow this can be achieved using SQL query.Appreciate your response.Jatin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-24 : 11:30:24
|
| do you mean values in different columns of row or are they in single column itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Selecting unique records from dataset WITH XML