Find Best Match

[RiverstoneJebin]

Hi,
I have 2 tables with same fields like event, venue, date and cost. Table 1 has 5 records and Table 2 has 100 records. How can i match a record from Table 1 with Table 2 to get the exact match record of Table 1 record. Event Venue fields are string datatypes which will not have same records. I need the nearest match .Please help me out. Thanks in advance.

[Plater]

This is really an SQL based question (unless you REALLY want to do it in code).
Perhaps a mod could it move it to the SQL section for you?

[bldink]

Personally, I find that you could do this in either place, app-side or SQL-side. Frankly, with there being only 200 records x 5 records that means the greatest number of scans that would take place would be 5 complete scans over the 200 records to a maximum of 1000 records (still really small).

Also, if done in SQL, or DB side in general, you can minimize this by only selecting those from Table 2 where they meet some criterion from Table 1 like the date and cost. If you are savy enough to create CLR stored procedures, you can do the whole thing in there; utilizing .NET's superior expressions to allow matching of similar strings.

Post Note: If you know that the columns "Date" and "Cost" in T1 and T2 could/will match, then you could "fuzzy" match them DB side if there is only one record returned with that exact date and cost.

Hope this helps...