Same, corporate has blocked access to any generative AI website for legal/ethical/copyright reasons.  Personally, I have used it create logic shells for languages I am less familiar with that I...

This anwer works for the given data but wouldn't work if we inserted a row like:

insert into #new(id,keyvalue) values (1,'bb')

The stated answer assumes a duplicate is defined by the ID...

per the comments in the msdb.dbo.sp_get_composite_job_info sp the state values are defined as follows:

0 = Not idle or suspended,

1 = Executing,

2 = Waiting For Thread,

3 = Between...