InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 14:30:43 GMT20http://www.sqlservercentral.com/Forums/Topic960522-1292-1.aspxHi,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 Num26 22 1 2 34 63 18 93 96 8My result should be 6 23 18 9Can this be done without using loops...Thu, 28 Apr 2011 04:30:22 GMTdinesh.spnhttp://www.sqlservercentral.com/Forums/Topic960522-1292-1.aspxPlease provide the DDL for the tables and examples that you have already triedThu, 29 Jul 2010 03:21:26 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic960522-1292-1.aspx[quote][b]varunfilim (7/29/2010)[/b][hr]Hi friends,I have a scenario where the table values areID First Second1 6 21 4 21 2 22 6 12 4 12 2 1From this table I want to generate a combination where Next ID values is max(previous ID) ie 3 and a combination of first and second which didnt come in the Previous combination, for eg3 6 23 4 13 2 2Can any solve this issue...help appreciated...[/quote]Umm, why not: -3 6 23 4 23 2 2??Just want to understand the actual requirement before I spend some time.Thu, 29 Jul 2010 03:11:29 GMTCadavrehttp://www.sqlservercentral.com/Forums/Topic960522-1292-1.aspxHi friends,I have a scenario where the table values areID First Second1 6 21 4 21 2 22 6 12 4 12 2 1From this table I want to generate a combination where Next ID values is max(previous ID) ie 3 and a combination of first and second which didnt come in the Previous combination, for eg3 6 23 4 13 2 2Can any solve this issue...help appreciated...Thu, 29 Jul 2010 01:01:18 GMTvarunfilim