Heh... you didn't try to...

• This reply was modified 5 months, 2 weeks ago by  erics44.

I think one of the issues with the data is that with so many rows there are lots of different problems to solve

many main ids to one joiningid for example

-- Create TableA

CREATE TABLE TableA (

MainID INT,

JoiningID INT

);

-- Insert data into TableA

INSERT INTO TableA (MainID, JoiningID) VALUES

(605014, 964999),

(605017, 965144),

(605036, 965186),

(605039, 965198),

(605103, 965234),

(605104, 965225),

(605105, 965201),

(605110, 965199),

(605111, 965227),

(605114, 965243),

(605135, 965258),

(605136, 965257),

(605168, 965255),

(605171,...

• This reply was modified 5 months, 2 weeks ago by  erics44.

I have combined the two tables so its just one table Id like to find the groupings of MainIDs joined by the joining IDs.

so its like a zig zag joining,...

• This reply was modified 5 months, 2 weeks ago by  erics44.

The Chat GPT thing is interesting, its taking over the world

I have added a spreadsheet with some data, if anyone could help it would be fantastic

Thanks everyone for the light hearted replies

I won't make this mistake again haha

Ok 👍

As soon as I'm back at a pc I'll send it over

Haha how do I do that?

In an attachment?

Excellent mate, thank you

ok great thanks

Thanks again, I'm going to start today 🙂

thanks a lot for the reply, I know its not ideal not having everything in source control, its is a task on the list I am told

another question

Does the "Pull...

The current process is, the devs dev 🙂 and then once finished they create a script and send it to the dbas who run that script in management studio

I dont...

I haven't tried SSDT, id like to though

its completely new to me so I'm not sure how it could help, could you give me a start please

Create/alter procedure should be the first statement in a query batch

thanks for the reply