I did google, couldn't see anyone ask a similar question nor when looking through keyboard shortcuts could see it, so as a last resort thought I would see if I'd...

Thanks for the replies, in the case above it's where the value has changed to a 12 or been set to a 12 within the month specified.

So I would like...

Thanks for all the replies, will have to review them all in more detail.

Insert into #Demo

Values (1, 12, '2019-09-01T07:00:00'),

(1, 12, '2019-09-11T07:00:00'),

(1, 12, '2019-08-05T07:00:00')

The above should return 0 rows as the...

Thanks, you understood the issue perfectly.

I did, to simplify the issue not give full details of the audit table. It contains millions of rows and the primary key is an...

• This reply was modified 5 years, 1 month ago by  robtyketto.