I would like it if the Blogs & their comments were more tied into the forums. Keep the Blog posts and comments pages visibly the same, but make the...

What do you mean by "See it"?

If you mean that you cannot see it on the browse list, don't worry about that: it's terribly inconsistent. Just type...

Not in SQL Server.

It's a fair point, alastair. In retrospect, although I knew about this layers of formula accuracy issue, I failed to take it into account in my article's original statement....

And yet, in this case, it is.

Yes, do what Gail said.

Friggin' right, Gus!

You know, I can understand (a little bit) not reading BOL: it's huge, intimidating, could be hard to use for...

In that...

My nominee for the week: http://www.sqlservercentral.com/Forums/Topic658615-1281-1.aspx?Update=1

*sigh*

sql server developer (2/17/2009)

---

Hi all,

I've a queue that gets activated by a stored proc. But the queue is not getting activated by the...

Ooookay. You know, I am just going to resist the temptation to whip mine out and compare here.

😀

Well let's see, BCP & BULK INSERT will not load XLS's, AFAIK, so they're out. So, that leaves:

A) SSIS

B) Dynamic-SQL driven OPENQUERY(sp?) tricks

C)...

alastair (2/17/2009)

---

Of course, if you are using SQL Server 2008, you don't need to use spherical approximations such as this - just use the inbuilt spatial functions:

Point1.STDistance(Point2)

STDistance() gives a more...

Nope,...

kevin (2/17/2009)

---

Because the earth is not strictly spherical (it "flattens" a bit due to its rotation), there's a mathematical adjustment that can be made which makes the result even more...