It appears that the 'enabled' button only works if user clicked disabled (sets inactiveflags to 128), so a value of 4 or 8 needs to set to 0 via update...

thanks for reply, but no just 1 datasource, and some subscriptions for same report are ok, just some are disabled, change to enabled via browser immediately back to disabled (it...

yes and lots of others but to no avail, I'll try to attack it in a different way.

thanks

Hi Phil, sorry for typo's,

The actual TSQL error from this line "from apyori import apriori" is

Msg 39004, Level 16, State 20, Line 63

A 'Python' script error occurred during execution of...

Yes I guess the physical 'date' is somehow influencing @@DBTS, as the database is not changing at all.

I haven't checked at 11:59pm and 00:01am 🙂 just end of working day...

No deletes, I've already asked that 🙂

They just set a status of the record to 'closed/lost/cancelled' etc.

It is curious though, if you

create a blank DB, create a single table with...

Hi Phil,

Absolutely can do that subtle change, but thank you for confirming approach of MAX(field) is good when used against Rowversion.

I thought it would be but thanks.

Hi Phil,

Thanks for the info and suggestion, yes the source table/field is a rowversion column and I need to query it to just pull back records (daily/hourly etc.) that have...

thanks for the reply.

It is really simple isolated table, just for testing

PriKey INT, VerCol rowversion, FieldB varchar(50)

I have now also copied this to another box that does not get SQL...

Hi Jeffrey,

Thanks for the reply.

Yes  I had already presented those options, but this is for country managers and VP's who want it delivered to them as they do with all...

Yes, unfortunately it looks like I will have to create specific code for the limitation of the Treemap object. I wanted to make sure I was not missing some piece of...

Yes that is the problem.
It treats it as an absolute value so interferes with the 'common sense' objective of the tree map.
As the smallest values all exist in...