Posted by Greg D. Moore \(Strider\) on 03/06/07 20:39

"SQL Learner" <excelmodeling@gmail.com> wrote in message
news:1173140746.926758.48820@h3g2000cwc.googlegroups.com...
> Erland and Greg,
>
> Perl is not my thing. Beside, in this project there are actually two
> tables that need to be links. The thing is that since many records
> can only be linked using partial criterial (ex: "123" to match "abc123
> xyz"), I still need to do this in a database.

Well perl's not my thing either. ;-)

That's why I keep several perl buddies handy for stuff like this.

Quite honestly, someone know knows perl REGEXP inside and out can probably
knock off the pattern matching script in 30 minutes or so.

But yeah, if you're the only guy on the job, that's probably a non-starter.


>
> Russ,
>
> If I do this through ODBC by using Access as the front end (query
> only) and SQL Server as the end back, how much slow down would this be
> compares to run the query on SQL Server without using the ODBC linked
> to Access?

Yeah, definitely run it on the server. Network lag alone would kill you.


>
> Thank you all.
>
> - Grasshopper -
>

--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

[Back to original message]