"War Horse"

That is not a proper join clause, though it may work (somehow) for Access.

try this:

SELECT (your select list)

FROM AR_CUST_MAST a

INNER JOIN SO_PAST_INV_HEAD c ON a.CUSTOMER_NUM = c.CUSTOMER_NUM

AND c.SHIP_REF_DATE Between...

Sounds more like a hardware, disk space or permissions issue to me based on the error message.

GilaMonster (2/16/2012)

---

That's most likely data caching (data pages cached in the buffer pool), not plan caching as the plan would have been reused for all unless you did something to...

It will be recompiled when table structure changes or significant changes in table indexing and statistic s take place.

Make sure you statistics are always up to date, but the plan...

Steve Jones - SSC Editor (2/10/2012)

---

Richard Sisk (2/10/2012)

---

It works quite well, we have key change procedures that are used to regularly update the keys. If a backup is stolen, it's...

AFAIK unless you can configure the driver somehow to map that for you that...

I have been able to seamlessly handle varchar(max) with older ASP and vb-script code that expect 'text' by using "DataTypeCompatibility=80" in the connection string. There might be a setting...

Gianluca Sartori (2/16/2012)

---

Use PortQry to test the sqlbrowser service from the client machine.

If you can't connect to it, you can't connect to named instances (you wouldn't know which port to...

phew. At least we know there isn't some obscure unreported SQL server bug. :hehe:

I did note the query you posted, and did try to duplicate it as closely as possible on a test table.

Not having your exact table on hand I could not...

CTE or not, a syntax error is a syntax error. I'm happy the OP resolved his issue but I like to...

What driver are you using for the ODBC datasource? Try using SQL Native Client (SQLNCLI10). If it doesn't show up in your ODBC applet you'll need to install...

kinda looks like a homework question to me. 🙂

I just ran a test on a big table that had a varchar() column with several different values in it. I did a count(*) and used a case like yours...