•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 373,479 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,936 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 830 | Replies: 5
 |
•
•
Join Date: May 2007
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 1
Newbie Poster
i have table
(id1,id2)
1.row [1,2]
2.row [2,1]
3.row [3,4]
4.row [4,3]
5.row [5,6]
6.row [6,5]
i want to get result:
1.row [1,2]
3.row [3,4]
5.row [5,6]
or
2.row [2,1]
4.row [4,3]
6.row [6,5]
i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you help please, how i get my result?
Rado, thanx very much.
(id1,id2)
1.row [1,2]
2.row [2,1]
3.row [3,4]
4.row [4,3]
5.row [5,6]
6.row [6,5]
i want to get result:
1.row [1,2]
3.row [3,4]
5.row [5,6]
or
2.row [2,1]
4.row [4,3]
6.row [6,5]
i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you help please, how i get my result?
Rado, thanx very much.
•
•
Join Date: May 2007
Location: Warrington, England
Posts: 31
Reputation:
Rep Power: 2
Solved Threads: 2
Light Poster
It's Not Too Clear What You Want.
1. A Query That Gives You Rows Where id1<id2 ?
2. A Query That Gives You Rows Where id2<id1 ?
You Mentioned Temporary Tables, So Either You're Making Things Too Complicated Or I'm Completely Missing The Point !
1. A Query That Gives You Rows Where id1<id2 ?
2. A Query That Gives You Rows Where id2<id1 ?
You Mentioned Temporary Tables, So Either You're Making Things Too Complicated Or I'm Completely Missing The Point !
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
select distinct case when id1<id2 then id1 else id2 end, case when id1<id2 then id2 else id1 end from tablename
•
•
Join Date: Mar 2007
Posts: 28
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
select t1.*
from theTable t1 join theTable t2
on t1.id2 = t2.id1 and t1.id1 < t2.id1
from theTable t1 join theTable t2
on t1.id2 = t2.id1 and t1.id1 < t2.id1
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
•
•
•
•
Originally Posted by cfAllie 
select t1.*
from theTable t1 join theTable t2
on t1.id2 = t2.id1 and t1.id1 < t2.id1
I don't have time to test this, but i don't think that this will work. This won't show any id1's that don't have a matching id2 or any id2's that don't have a matching one
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
access ajax asp breach broadband code combo crime daniweb data data protection data transfer database developer development drive dropdownlist forensics government hacker hard hardware hitachi internet linux microsoft module msdn net news office reuse security software sql storage survey terabyte vista web wikipedia
- Data Recovery (Storage)
- How do you access Data in a QBasic 2.0 Data Table (Legacy and Other Languages)
- data file help (C)
Other Threads in the MS SQL Forum
- Previous Thread: Best book for SQL Server 2005
- Next Thread: Database Query Help
