I am slightly confused.  Are you doing restores to the same point in time each time you do a restore?  Also, what are you attempting to achieve with these restores?

>> I have sadly run into the issue where I don't actually know the question to ask to get the answer I need or to be able to formulate...

>> I have a database with three tables linked [sic] together by 'DocumentNo'. Two main linked [sic] tables which output all rows with a full outer join. These...

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...