Thank you for this article. It works but the final HTML output is broken. I guess it has to do with the tags and since I am not well versed...

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')

...

Hi ChrisM,

Here is the full query:

USE MYDATABASE;

GO

SET NOCOUNT ON;

;WITH GuestStay ([ReservationStayID],ArrivalDate,DepartureDate)

AS

(

SELECT ReservationStayID,ArrivalDate,DepartureDate

FROM GuestNameInfo

WHERE YEAR(ArrivalDate)=2014) AS X([ReservationStayID],ArrivalDate,DepartureDate)

)

,T(N) AS (SELECT N FROM ( VALUES (NULL),(NULL),(NULL),

(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

,COUNTING_DAYS...

Hi Eirukur,

I'm afraid it's still not working for me. I'm sure I'm doing something wrong with the syntax! Grateful if you could have a look and point out the...

Thanks, Eirikur! Got it now! I should have read more attentively! Thanks again! 🙂

Eirikur Eiriksson (9/23/2014)

---

Here is the same code with the changed name and some explanatory comments. I noticed I had left the month sequence in the other code without using it,...

Thanks a lot, Eirikur Eiriksson! Wow! I wished I could write SQL queries that good!

I'm a bit confused with the first part of the query (blame that on my...

Thank you for your solutions guys! Sorry for getting back late on this topic.

I am still a bit confused at the final solution proposed by ben.brugman.

If I understand well, my...

Thanks, Lowell! 🙂

Thanks mister.magoo and bitbucket! Wow, I didn't know it was so complex to do that! SQL Server being a Microsoft product (same as Excel), I believe there should have been...

Thanks for pointing this out, Grant! Indeed, very important to know!

Ok thanks GilaMonster!

It works!! Thanks a lot, twin.devil!:-)

Thank you Koen...but I'm still confused. I don't have Excel 2013. I'm currently using Excel 2010. Do you mean that I need to have Sharepoint installed?

Thanks SSC! I downloaded that version from the Microsoft website and it installed without a glitch! 🙂