Disclaimer: you haven't given enough info to give a decent answer, and I question whether geometry is the best choice here.

That said, look here

First reaction is use 2 columns of type float. There may be specific reasons to use other means, however. Without knowing the specifics it's hard to give a better...

Lowell (11/23/2010)

---

a whole lot of knee jerk reactions about "but it's not supported!", but since it works on SQL 2008 ( and someone reported it works all the way...

Tom.Thomson (12/18/2010)

---

I learnt zilch from the explanation; the BoL article referenced doesn't seem to contain any statement supporting the answer it is supposed to support, which is irritating. The...

Tom.Thomson (12/18/2010)

---

Nice clear question and answer (apart from the typo in the explanation).

BUT: the more I see of this stuff the more I think the way XML was introduced into...

Hi madlan,

No guarantees on the sort order of any SQL results unless you use the ORDER BY clause.

Thanks

Michael

bkv (12/10/2010)

---

Thanks, good article.

But there is one thing which is a bit confusing me.

When I am trying to do a search like 'test (' or like 'test and'

I am...

dma-669038 (11/23/2010)

---

No offence to this particular author but there are lot of scripts and lot of authors who write very custom scripts, scripts that will work in some situation/some environment...

I was wondering the same thing when I saw the throughput -- 1,000 recs/min.

fat wallet (11/22/2010)

---

From the perspective of a professional DBA and Dev, this is useless. First, it is troublesome. Second, it cannot guarantee pulling data correctly. Third, it does not give...

TRACEY-320982 (11/21/2010)

---

With this information would you be able to replicate the data to another database. Most of the software we use does not have primary keys so SQL Replication...

I'd like to stress a point the author mentioned in passing: this function is UNDOCUMENTED. What does that really mean? Well, to summarize:

1) Microsoft does not support the function. If...

madlan (11/18/2010)

---

Great article, been looking for something along these lines.

I'm wanting to display the rank as a % and order by this to move relevent results to the top, how...

Better yet, just use the attached script. It has 4 CLR functions that do what you asked.

Enjoy,

Mike C

The first issue is probably trying to use the 32-bit dll's on a 64-bit system. Second issue is that binary to float conversion is not supported in SQL...

Ping me...