Of course I am in, you all need a target.

I enjoyed the movie.  Too bad you hated it.

So today got awesome. Just minding my business, had a request in to start a Git repository for my team to finally get us into source control and out...

I guess my wife would say I need...

Don’t make me post some examples. The issue isn’t so much the implicit join but rather understanding the criteria in the WHERE statement when it contains the join...

To be safe I would put the database name, schema name, and table name inside the QUOTENAME() function.

Actually, I found the code I was looking for, it was in my Azure database.  The code itself is not very usefully on its own as you need to see...

I'm not sure at the moment.  I was unexpectedly busy this weekend and did not have a chance to look for the code I think may help in this situation...

I may have something that you can look at but I don't have it available at work.  When I get home I will see if I still have what I...

You posted one set of sample data but you failed to provide your expected results based on that data.  Also, what if the number of "orders" during the span changes? ...

Could you also post sample data and expected results based on the sample data?  If the number of "orders" can change you may also want to post a couple of...

Without creating a truth table I can describe your first three rules in this manner:

For drugs A, B, C if prescribed and filled within 30 days of each other:

IF A...

Here is the place to start:

https://www.google.com/search?q=truth+tables&rlz=1C1EJFC_enUS816US816&oq=truth+tables&aqs=chrome..69i57j0l5.2671j0j7&sourceid=chrome&ie=UTF-8

I learned about them back in the late 70's while taking a micro electronics class in college.

• This reply was modified 6 years, 2 months ago by Lynn Pettis.

One thing I will tell you that may help is to create a truth table using the rules.  Working through that should help answer your questions regarding the interaction between...

With the new SSC, everything is supposed to run through a dev/QA cycle before prod. We have PRs that require review before they get merged into a deployable...