What happens if the sum is not  exactly 30? Would you need to divide it? or should you move the whole row to a new page?

I must remind you that all days should be properly stored using the date data types. Format should be used for display only (or maybe some calculation hacks).

Congratulations Brandie!
Just take care as it seems that the weather won't be great for Florida these following dates.

Try this code (adapt it to your table) to find out what the problematic character is.

WITH
E(n) AS(
  SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n)...

It's good to know that I'm not alone in my despise for IPAs. I don't understand how they became so popular and some bars here will offer them as 80%...

There's one more alternative:

SELECT per.FirstName,
    per.LastName,
    emp.JobTitle,
    emp.HireDate,
    COUNT(*) OVER(PARTITION BY emp.JobTitle) Totalemployeeinthatjobtitle
FROM Person.person per
INNER...

Similar to Jason's solution. The CTE is only to create sample data.

WITH SampleData AS(
  SELECT 'New York' + char(9) +'Washington' + char(9) +'Los Angeles' +...