Click here to Skip to main content
15,887,214 members
Home / Discussions / C#
   

C#

 
GeneralRe: how to Access to Other form when it's still in "Show()"? Pin
I Believe In GOD24-Sep-07 11:44
I Believe In GOD24-Sep-07 11:44 
QuestionHelp File integration Pin
Muhammad Nauman Yousuf24-Sep-07 2:38
Muhammad Nauman Yousuf24-Sep-07 2:38 
AnswerRe: Help File integration Pin
Justin Perez24-Sep-07 2:50
Justin Perez24-Sep-07 2:50 
GeneralRe: Help File integration Pin
Muhammad Nauman Yousuf26-Sep-07 2:47
Muhammad Nauman Yousuf26-Sep-07 2:47 
QuestionFind Exact match Pin
jebin k24-Sep-07 2:29
jebin k24-Sep-07 2:29 
AnswerRe: Find Exact match Pin
Guffa24-Sep-07 2:38
Guffa24-Sep-07 2:38 
GeneralRe: Find Exact match Pin
jebin k24-Sep-07 2:51
jebin k24-Sep-07 2:51 
AnswerRe: Find Exact match Pin
Guffa24-Sep-07 4:35
Guffa24-Sep-07 4:35 
jebin k wrote:
all the Records in Table 1 and Table 2 will not be same.


That's a funny definition of "exact match". Wink | ;)

jebin k wrote:
I need the nearest match from Table 2 for Table 1 record.


You can count how many of the fields that match with something like:

case when t1.Event=t2.Event then 1 else 0 end +<br />
case when t1.Venue=t2.Venue then 1 else 0 end +<br />
case when t1.Date=t2.Date then 1 else 0 end +<br />
case when t1.Cost=t2.Cost then 1 else 0 end


You can sort on the value using descending order to get the best matches first, and filter out only the matches that reaches a certain value.

You can use other values than 1 in each case if you want the fields to have different importance.

---
single minded; short sighted; long gone;

GeneralRe: Find Exact match Pin
jebin k24-Sep-07 7:28
jebin k24-Sep-07 7:28 
AnswerRe: Find Exact match Pin
Justin Perez24-Sep-07 2:42
Justin Perez24-Sep-07 2:42 
GeneralRe: Find Exact match Pin
jebin k24-Sep-07 3:10
jebin k24-Sep-07 3:10 
GeneralRe: Find Exact match Pin
J4amieC24-Sep-07 4:05
J4amieC24-Sep-07 4:05 
Questionhelp to create inventory system?? Pin
cutedrew24-Sep-07 2:27
cutedrew24-Sep-07 2:27 
AnswerRe: help to create inventory system?? Pin
Colin Angus Mackay24-Sep-07 3:30
Colin Angus Mackay24-Sep-07 3:30 
QuestionThe equivalent of 'hello world' when it comes to custom events?! Pin
Dave2560024-Sep-07 2:25
Dave2560024-Sep-07 2:25 
AnswerRe: The equivalent of 'hello world' when it comes to custom events?! Pin
martin_hughes24-Sep-07 3:46
martin_hughes24-Sep-07 3:46 
QuestionGenerate C# code from Visio diagrams Pin
Krishnaraj Barvathaya B24-Sep-07 1:55
Krishnaraj Barvathaya B24-Sep-07 1:55 
QuestionVirtual listview Pin
Hampus@foi24-Sep-07 1:40
Hampus@foi24-Sep-07 1:40 
AnswerRe: Virtual listview Pin
mav.northwind24-Sep-07 2:07
mav.northwind24-Sep-07 2:07 
GeneralRe: Virtual listview Pin
Hampus@foi24-Sep-07 2:13
Hampus@foi24-Sep-07 2:13 
GeneralRe: Virtual listview Pin
mav.northwind24-Sep-07 8:19
mav.northwind24-Sep-07 8:19 
QuestionAdvice on WCF configurations Pin
BigBenDk24-Sep-07 1:38
BigBenDk24-Sep-07 1:38 
AnswerRe: Advice on WCF configurations Pin
Pete O'Hanlon24-Sep-07 1:55
mvePete O'Hanlon24-Sep-07 1:55 
GeneralRe: Advice on WCF configurations Pin
BigBenDk24-Sep-07 2:02
BigBenDk24-Sep-07 2:02 
QuestionCreating crystal report for windows applications Pin
iet200024-Sep-07 1:21
iet200024-Sep-07 1:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.