Just replace the BASE_TABLE CTE with...

There is a big difference in the results when doing the calculation on geometry or geography, look at this examples and results

😎

Geometry

USE tempdb;

GO

DECLARE @GEOM TABLE

(

GNAME...

goldstone.david (9/24/2014)

---

I have an SQL issue that I cant solve and I need some help with it please. The attached file is an extract from a sql server data warehouse...

Sounds a little like travelling salesman here:-)

This isn't too high of a volume, cannot say much...

Jeff Moden (9/23/2014)

---

Do you understand how it works so you can support it in the...

Lynn Pettis (9/23/2014)

---

Eirikur Eiriksson (9/23/2014)

---

Try this for a size

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA ([ID number],DateOfArrival,DateOfDeparture)

AS (SELECT * FROM (VALUES

(2031,'2014-03-20','2014-03-26')

,(1056,'2014-04-29','2014-05-03')

...

Firstly, Using 8K limited functions will of course truncate larger values, does your production data exceed that limit? Secondly, please comply to Chris's request on DDL, sample and output.

😎

Quick question, do you have the option of...

Quick question, how accurate does this have to be? The reason for asking is that one can do a good approximation using the spatial data type methods and functions, happy...

Quick suggestion, gracefully power down the system, reboot using a good recovery distro such as backtrack, gparted etc., DON'T mount the drives but use dd_rescue to image the drive or...

Quick thought, I've found that using the import/export...

stefan.mulder (9/24/2014)

---

Great stuff!

but as to Jeff's notes on collation: we do need a function that can handle compound delimiters, e.g. [|;] or [","] as in David Data's case of...

A Lorry be a wagon that can carry lots o' gold and precious

😎

You will have no joy thar, they be already walkin' t' plank

You must take it t' t' witchcraft Island, thar be an old beauty thar which has t' power...