What if it's down for more than 24 hours? How can you tell with no dates?

What do you need help with? Designing your database tables? Or writing code to parse IMDb? The latter would be beyond the scope of a database. The former we can...

I may be stupid and just missing something obvious, but I don't see where you're storing dates at all. You're only storing time and day of the week. So how...

T-SQL does not have a native BetaDist function. You can buy statistical packages/add-ons that include it, but one that I looked at was $600.

I'm not a statistics wizard, so...

I actually didn't know you could use BETWEEN in this way, for (var)char datatypes. And without the wildcard % operator. Groovy.

Holy cow!

I can't rival the other guys on this board, but I am using this as practice for myself and would like (constructive but friendly) feedback on the solution I came...

Perhaps "wizardry" would have been more appropriate, but I had a little alliteration thing going there with the "t's", so... 🙂 I'm certainly in awe of you cats and your...

I knew it'd just be a matter of time before someone posted some Cartesian tally table trickery. 🙂

This might be too low budget a solution for you, but what if you simply created another table that had every possible date in it? Then it would simply be...

Yeah, honestly I'm not clear on the specifics of it either. But conceptually I understand what it does, and this seems to fit the bill AFAIK... I hope you'll report...

I think Sean was unclear on the specific failure you were encountering, not unclear on the phrase "where filter". No need to be snippy.

Would UNPIVOT possibly be helpful in this type of scenario?

Be sure you are clear on the difference between UNION, and UNION ALL. Give a holler if you need any more help. 🙂

If I'm understanding this correctly, it looks like you probably want to create a single CTE that holds the contents of all 3 of your select statements. You can combine...