April 28, 2011 at 4:34 am
Hi,
I Have similar requirement. If anyone solve this, pls let me know. Explanation of the problem.
Consider i have two columns with combinations of numbers. I want to pick the genuine combinations of numbers which doesnt involve in other valid conbinations. For ex.,
Num1 Num2
6 2
2 1
2 3
4 6
3 1
8 9
3 9
6 8
My result should be
6 2
3 1
8 9
Can this be done without using loops...
April 28, 2011 at 6:18 am
Funny, this is almost identical to this question. Is this homework?
At any rate, your answer can be found here.
http://www.sqlservercentral.com/Forums/Topic1094079-392-1.aspx#bm1094158
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply