you would need to join to a table of hours and outer join the two...

SELECT Hrs.[TheHour]

,Movie.[StartTime]

FROM Hrs LEFT JOIN Movie...

After looking at this and playing with it for a little while, I stand by my original conclusion - you need the UNsummarized data from somewhere. If you can talk...

do you have the unpivoted data somewhere?

Maybe this article?

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

This is Lynn Pettis' calculation[/url] for first day of the next month...

select dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0) -- Beginning of next month

last day of the month is the...

normal way to post is like this...

SELECT '2016-01-31' AS plant_date

, 4 AS History_Ind

, 3143 AS Prop_Code

, '2016-01-19' AS Void_Start_Date

, '2016-03-14' AS Let_Date

, 'Void' AS Void_Status

UNION ALL

SELECT '2016-02-29',4,3143,'2016-01-19','2016-03-14','CFWD'

UNION ALL

SELECT '2016-03-31',4,3143,'2016-01-19','2016-03-14','CFWD'

UNION...

This

cast( cast(year(plant_date) as nvarchar(50))+'-'+cast(month(plant_date) as nvarchar(50))+'-1' as datetime) as plant_date

is a calculated column in your Calendar table.

Sounds like you might want to look up Calendar tables. Here's a good...

Why not just use a Calendar table... you can use a table-valued function to generate a list of dates on the fly. Then it's just a pure count.

A few questions...

1. what's your date format? is that MM-DD-YYYY or DD-MM-YYYY?

2. please explain in English how to get your expected answer. (what does your data mean?)

Another thing... if you...

post what you tried. Part of learning SQL is trying something, and failing, learning from your mistake, and trying again.

What happens when you run the stored procedure inside SMS, not SSRS? Is there a chance that you're connecting to a different server that has a different copy of...

Brandie,

Just wondering... how did you build your machine that you tore apart all the time? A Virtual Machine? I might have to start doing that...

The 2004 ALCS must have been one for the record books in your house... You gotta admit, it was a pretty good series - the WS after that was positively...

Maybe try RedGate SQL Compare

DelimitedSplit8K will do that for you... the code for it is here[/url]:

SELECT *

FROM dbo.DelimitedSplit8K('777777777777777777 0 0 0 0 0 0 0 16090 0 0 0 0 0 0',' ');

The...