Oh I see, it's a CONTAINS operator...

What is "FORMSOF(INFLECTIONAL. "?

Oops, never mind about the code request. I infer from the discussion above, that you do not yet have the full features done for the code side either?

If that's...

lou-612048 (3/6/2010)

---

...

I have a full-text search that works in an ASP environment that takes whatever's entered into the search field, doing some sanitization, then breaking apart the search phrase into...

EdVassie (1/16/2008)

---

We make extensive use of free text searching where I work. John is right, you need to construct a dynamic SQL query using the data supplied by the...

GilaMonster (3/6/2010)

---

RBarryYoung (3/6/2010)

---

Joins are not "better" than sub-queries. They are not even "in general" better than subqueries. They are "in general" about the same thing, but it always...

arun.sas (3/5/2010)

---

Jeff Moden (3/5/2010)

---

Colin-232036 (3/5/2010)

---

One table has many fields. And in the table,it has a clustered index on a fieldA, and a nonclustered index on a fieldB. I...

Thats probably the best way to do it. Except that I'd make "Distance" a range, that is, two int columns: MinDistance, MaxDistance. (change it in the PK too).

IIRC, the Merge call is usually preceded by one or more Writes and Reads, and what I can't help but notice in your code is this possible sequence:

Accumulate: sets Count,...

I don'y know AWE well enough to answer your questions about it directly, I'll let someone more familiar do that. I can however help with the rest of it....

Jack Corbett (3/5/2010)

---

For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be. If...

you'll need to show us your actual SQL code.

info 54357 (3/4/2010)

---

I'm not so smart today. I should have said that form data bits A and B are small text strings, which I'd set up like this: @A ntext,...

Tom.Thomson (3/4/2010)

---

edit to fix spelling (English spelling is awful/impossible:(, whether US version or UK version; maybe I should add something like "Tha mi sgith de litreachadh na Beurla" to my...

Tom.Thomson (3/4/2010)

---

(What's the betting that someone who thinks they know what a recursive function is will come up with integer addition as an example of a non-recursive effectively computable function...