jay-h (6/4/2012)

---

I did not understant what IBM's objection was when I read the news article. How does this differ from doing a Google or Bing search?

Not that Siri interests me...

Thanks, opc.three.

Hugo Kornelis (6/1/2012)

---

...

1) Sometime MS SQL table or column names are enclosed in square brackets in queries (e.g. if contains spaces or for some other reasons). MySQL does not allow...

Jeff Moden (6/2/2012)

---

RBarryYoung (6/2/2012)

---

Jeff Moden (6/2/2012)

---

I'll say "IT DEPENDS". Let's have a race. You write a CLR...

Jeff Moden (6/2/2012)

---

I'll say "IT DEPENDS". Let's have a race. You write a CLR function to solve...

Glad we could help.

weisen678 (5/28/2012)

---

SS, now, I have tried again, this time I get a red leggy under my column name 'inventoryQty', when my mouth over, I get this message,

Invalid column...

dwain.c (5/28/2012)

---

Barry,

I humbly apologize for having to say this but I could only get your solution to work by changing id_phone in the subqueries to...

Jeff Moden (5/28/2012)

---

Rock from VbCity (5/28/2012)

---

The in-line table valued function handled the 1.6 billions records in around 1 second, the CLR function took a bit more than 6 seconds while...

Then you need to use profiler to see what's really going in SQL.

Glad it worked out for you then.

Something like this should work:

;WITH ctePhones AS

(

Select cp.id_client,

cp.number,

...

Offhand it appears that your Access form is not filling in either one of the ContactName or the Organisation columns.

It has to do with what kinds of things the function is doing, not so much how many rows are in the table.

For the example that you posted, a simple...

How does the working new server/database compare to the non-working new server/database?:

1) Same box, different instances, same DB name

2) Different boxes, different DB names

3)...