I'm still struggling to adapt the articles based on the examples.

Maybe I simplified it easier on the previous example.

I've mocked up a more "realistic" data set but still cannot get...

from your use of "reverse" it seems that you wish for the elements to be returned in reverse order - why?

and if this is the case how does it...

Thanks Jeff, I think I've confused everyone with the questions, but the solution I've done is as below. Hopefully makes a bit more sense.

Re: the MeetingID this is basically a...

Was having a blank moment, I've got it  just now trying to work out next stages regarding the grouping but least I've made progress.

The JOIN I did was the below...

Just adding, I can do an Exists Check to ensure that the meeting exists but I can't group it which is where I'm stuck.

AND EXISTS (
SELECT *...

I'm looking to group the meetings based on their start/end time for which falls in that week period.

I've attached a small screenshot which shows Group 1 and Group 2 for...

• This reply was modified 3 years, 1 month ago by  Tava.

I think I may not have explained it correctly or I am overthinking.

I can't join the 2 tables since there is no reference between the 2.  The #dateresult table is...

• This reply was modified 3 years, 1 month ago by  Tava.

Thanks all, this has worked

Thanks all, didn't think of these ways. I'll update these later today and let you know how it goes.

Thanks again

Thanks for the information, I've decided to not use CDC for that reason and for the temporal tables at this stage i've also kept this as an option in the...

I've just read and if i understand it correctly,  it needs to have 2 additional columns added to each table (i.e. start/end date) which is something I probably would like...

Hey, thanks for the quick reply.

I posted in 2019 but I'm actually running 2017  standard which is still supported.

I did also think of CDC as an option but didnt think...

Isolation level used is READ COMMITTED.

Yeah probably what I wrote and what I meant might have come across a little grey. I pretty much wanted a Prod Restore on the UAT Server, but keeping both...

FYI, I've resolved the issue. I created it going down the path of using Elastic Query. it was a little bit clunky (in preview mode) but achieved the results.