Good stuff!

Out of curiosity, what is the output of

select @@version

after the fix?

😎

Nicely put!

😎

Thank you for the question Steve

😎

Here is a simple solution using CTE to build the full month-account set first and then join the balance table to it.

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

;WITH ACCOUNT_LIST AS

(

...

Quick question, is the database in SIMPLE recovery mode?

😎

Quick thought to rule out some problems, have you checked the logs for error messages or the output of DBCC CHECKDB?

😎

goldstone.david (9/24/2014)

---

So basically I dont need to enter all the red.. I just enter... the below? It will be impossible to enter all the values in red.

SELECT * FROM...

busraker (9/24/2014)

---

I would expect that given the large variation of lats/longs. All of my data points will be within 1 degree latitude and longitude so I think i can...

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.

😎