It's been a while since I've messed with negative boolean algebra so I hope I got this right...

The first one equates to NOT (invoice_cl  =  'INN1' OR PaymentStatus = 'Unpaid'). ...

I have to disagree a bit on hating "ordering" in an RDBMS... indexes would simply be of no use without "ordering".  The "order" of things is quite critical in RDBMS's...

Heh... "What a lot of money"?  It's the same question as "What's big data"?  It's something that you've not had to handle before. 😀

I'm pretty confused about what you're actually using for a source...

ISNULL has some bad quirks that can cause problems, although I admit I still use it at times, simply out of habit, although I never embed it (also, btw,...

Heh... MS should be sued for false advertising when it comes to their videos.  😉

I was trying to get the days so they would be dynamic rather than having to hard those each month.. I also wanted the channel to be sub-category of...

To me, it's a bit funny that someone would say that they're "less reliable" than views... they are one of the few things that operate precisely the way they're documented...

The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By...

Sure...

1. Like what was written...

The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By analogy,...

(THUMBS-UP) If it helps to leave the misconception behind,...

BWAAAA-HAAAAA! 😀  Let's not because then someone would want to...

Thank you for the reply. I tried that and the values in the original column are still the same.  Should that have output to a new column? I created...

In my company's case we use that date of 2078-12-31 as the maximum date because there are fields in some tables that are defined as SMALLDATETIME and since the...