Thread: Query runs, but never finishes....

> update a set a.public_id = b.public_ID from userlist a inner join member.dbo.members b on a.board_ID = b.member_number where a.board_ID is not NULL

> Hmmm, that seems to make sense but I get the same results - just runs forever.

> note, public ID is null on some of the records on Userlist - which is mostly what I'm trying to correct.

> There must be a mistake on joining i.e. in the data in both tables. Have a look at your data and have a special look at the possibility to join a.board_ID = b.member_number. Maybe the join matches 60000 with 6000 because of missing proper ids? No, you're never too old to Yak'n'Roll if you're too young to die.

> Are you familiar with Indexes? Do you know how to check if they exist on a table. That could be the issue. Are there any indexes on the tables?

> Denis that cannot be with only 6000 records. No, you're never too old to Yak'n'Roll if you're too young to die.

> something must be blocking your query. after executing it, open another window, type in "SP_WHO2" and look in the blocking column

> Try using hint - WITH (TABLOCKX) on the updated table

> Hi! Try as I would write: update userlist a set a.public_id = (select b.public_ID from member.dbo.members b where a.board_ID = b.member_number) where a.board_ID is not NULL Hope board_ID is a unique index or primary key. :) cheers!