1 Resources for

desbiens_mathieu@...

Sponsored White Papers, Webcasts, and Downloads

Performance Issue using left or substring function in Sql Server2005Express: Hi, I've tried the following query in SQL SERVER 2005, SQL Express 2005 and MACCESS. select * from Table1 where drid in (SELECT DrID FROM Table2 WHERE (substring(PostalCode,1,3) IN ('B0E','B1P','B2H','B2Y','B3A','B3M','B4A','B4H','E1A','E1C','E1N','G0A', …)) and (substring(Telephone,1,3) IN ('204','250','306','403','416','418','450','506','514','519','604','613','705','780','807','819','902','905'))) The query is using two table. The first one...; Tags: Databases, desbiens_mathieu@..., performance, MACCESS, Table1, Microsoft SQL Server, Table2, execution time, SQL, Microsoft SQL Server 2005; Discussion threads 2007-10-22

Harness the Full Power of Internet Explorer: This pre-packaged presentation contains everything you need to instruct end users about how to the most out of the Internet and Internet Explorer--eve ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now