My answer probably has some logic holes in it and not as elegant as yours Jeff, but this is what I put

When using the Month(18/200) or (200/18) the Resulting Int/Decimal...

The original Trivia question was for a $50 Amazon gift card.

It was why does MONTH(18/200) AND MONTH(200/18) both return 1's.

CAST INT to Datetime was part of me trying explaining...

This was a SQL puzzle that I was trying to figure out. This was one of the pieces. Trivia question basically not a real scenario.

Thanks Alan,

So is it correct to say that when adding or subtracting from datetime the default is Days?

Yes,

Wise owl tutorials is a good place to start they are free. I am currently helping my Company which was a 100% crystal over to SSRS. I do SSRS...

Is there anything Hardcoded in your query? Try changing your parameters and see if the results change.

I actually just took this exam last week. Yes much more of a trivia contest then a measure of skill. I'm doing the MCSA track because my employer is paying...

Yes, I believe SSRS Caches data.

Click Manage on your report then select the Processing Options tab.

Select Do not cache temporary copies of this report to always run the report with...

I do Luis, I do!! Forgot about my Calendar Table

Thank you sir!

So awesome guys. I love this stuff!

Very, Very cool.

Thanks for the explanation. Great learning experience.:-D

Great solutions! Thank you gentlemen. I am still playing with it and testing them out.

I have seen similar things with a Windows function but I am trying to dissect it...

Unless I am misunderstanding what you need. Why not use a split list. In SSRS set the Paramter to Multi-Select. Use a Split List function in your query.

SELECT DISTINCT Gbl_Parnt_Country...

Hello Jeff,

Is this because of the possible performance issue with using a cte and a wide/large table/results?

The current query is not bad I am only using 15 columns and 8...

Wow that was fast!

And its faster than my attempt at creating a temp table to build a start and stop time column.

Amazing 242,139 rows in under 30 seconds

I like it sir! I think I just replaced mine with yours. Most of our colors were the same but I did prefer some of the choices it gave me...