george sibbald (2/8/2010)

---

John, thats just perapatetic exogmatism.

At least SQL server is fully heterogenous with Oracles electro-encephalagraphic interface for SPC ( a cost extra I might add) simply by using the...

I have to laugh at all you Microsoft acolytes trying to master DBCC Time Warp.

If you'd been working with Oracle instead, you'd know that Ellison's minions realized the...

Hmmm. I'd always thought that "golf clap" was what you got if your ball went in the wrong hole.

Congrats, Jack!!

I would...

The "inconsistencies" I point to in this post may actually be controlled by the use of settings as pointed out by Paul White in a post later in this thread....

Hugo Kornelis (2/1/2010)

---

SELECT HASHBYTES('SHA1', REPLICATE(CAST('A' AS varchar(max)), 8000)) returns a 20-byte value, and SELECT HASHBYTES('SHA1', REPLICATE(CAST('A' AS varchar(max)), 9000)) returns the same warning message and no value. Why the IF...

Careful. It starts to be a sad thing when someone looks to the Thread for company on a Friday night....;-)

Hi. I just noticed that Wayne's given some ideas, but I haven't gone through them yet. Meanwhile, I worked up a simple case showing how a CTE and...

I would approach this with a CTE that provides a list of coordinates, then use RowNumber() partitioning while going through the CTE results to calculate distance between each successive pair...

I don't think that's quite right. ...

Paul White (1/26/2010)

---

BrainDonor (1/26/2010)

---

Steve, could you give this call a nudge - it appears to be stuck....

http://www.sqlservercentral.com/Forums/FindPost853470.aspx

The same message three times in a row - he's determined someone will write...

Yes, Paul gave you a script that works well per your request, but consider whether you'll be able to explain the use of a CTE (Common Table Expression) should anyone...

Gianluca Sartori (1/25/2010)

---

Grant Fritchey (1/25/2010)

---

GilaMonster (1/25/2010)

---

Didn't need to (and I think Grant has the...

Ah, thank you for the correction, Jeff.

Now I do wonder if the procedural loop need be done at the row level or if it could be done with...

Number one suggestion: Do NOT use a cursor or WHILE loop to do this. You can let SQL match up the reference table with the rows to be...