Glad we could help.

Is PCDate an index?

*sigh*

This is actually a really clever self-referencing play on words, but it only works if you already know what Amphibology means, and hardly anyone does anymore. 🙁

(OK, I had to...

Thanks, Gail. I don't know what happened, but it is working correctly now.

Cursors that have only one output target and have no sequentially dependent context, are relatively straight-forward to convert to set-based (straight-forward, but not necessarily easy because of how byzantine and...

Generally, that is not how these things work, a vendor does not...

Here is one way to do it:

SELECT EmployeeID

, FirstName+' '+LastName AS Employee

, (Select s.FirstName+' '+s.LastName

From dbo.Employee s

Where s.EmployeeID = e.SupervisorID) as Supervisor

, SiteID

, HireDate

FROM dbo.Employee e

Then you are probably going to need regular licenses.

Oksana March (11/28/2008)

---

I am surprise to so negative reaction to the question of Venkat. I have the same problem as his question number one and I would like to hear...

Then it will depend on the content of the training. If they are learning how to develop, then I believe that you could use the Development Edition licensing (still,...

Oops sorry, I don't think that you can get XML format in SQL 2000.

Can you show us the Execution Plan? in XML(.sqlplan) format?

andrewd.smith (11/28/2008)

---

One note of warning: the SARGable box does improve performance, but it causes the query to not find the nearest point if there are no points within this range...

andrewd.smith (11/28/2008)

---

It's not converting from great circle radians to miles - it doesn't need to because the query is just using the result of the trigonometric expression to order the...

What's to wonder? They didn't post because they did not know the answer.