Could it be the Query Governor?

Do you check for corruption using DBCC CHECKDB?

I sympathize with your situation. I have no technical suggestions because as you have suggested with the data changing there are no reliable solutions to the problem. Here are some...

I added start and end dates to table GroupMembers and added StartDate to the primary key. This is to track when an individual or groups enters/exits a group. I embedded the...

Thank you! Yes my expected results for 5 were wrong. I may post back if I have additional questions or enhancements which could prove useful to others.

Thanks Drew. Let me clarify if I can.

I would like to build a groups data structure that allows for a group to contain one or more individual members...

Finally was able to find this
decode-sql-server-job-schedules

Thanks for your response. Yes there have been different methods of populating this table. As Jeff said one of the methods is broken and needs to be fixed. I will...

I neglected to provide sample data that would illustrate a particular scenario and naturally the code Lynn provided does not address it. The

December 26, 2017 at 5:00 pm

#1973532

Yes that is exactly what I am looking for. This should help me eliminate 99% of the records. Thanks so much.

Thank you to all. I got all solutions to work, the CTE just needed a little adjustment as the poster suggested. The calendar table is quite simple and is probably...

The former.

drew.allen (10/10/2016)

---

Also, you're not testing for...

My use case is I have daily jobs that are scheduled to run at a specific time. I want to alert when a job did not run. I thought TIME...

Perfect thank you! I didn't know TimeFromParts existed and it is exactly what I was looking for.

Thanks all. I will be entering a development and testing phase and I will post back if I have any questions or something to add to the conversation.