Hi Chris,

I discovered that passing parameters to a VIEW wasn't possible, at least I don't think so.

So, as you've suggested, I created a STORED PROCEDURE with accepts those date parameters,...

Hi Chris,

One last item...

If I wanted to create a view for this statement whereby the initially declared variables (i.e. @MinOrderDate, etc.) could be changed when running it, what would that...

Hi Chris,

Thanks for this, it is an immense help!

OrderDate is in fact a DATETIME column and therefore unlikely that there would be Orders rows with identical OrderDates for the same...

@chris-2

Thanks for speedy and thorough reply!

This is exactly what I was looking for.

I will study up on this to grow my SQL chops.

It is possible that a Customer could have...

I should have prefaced my original post with what I'm trying to accomplish as my SQL knowledgebase is pretty limited.

Both solutions here work, but return different results, so I'll take...