See this http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/25/sql-server-2008-sp1-cu-6-includes-small-changes-to-dtsx-files.aspx
I distantly recall running into this. I think if you view the properties of the object rather than opening up in the GUI you can edit this...

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.