2011-11-03, 02:07 PM
SaptaZapta Wrote:Right! Via join.
I think he was thinking more along the lines of
Code:
insert into #t select min(date) first_quest_completed, characterid group by charecteridBut yeah, he'd still have to join to #t to get that which would be redundant, and annoying for a delete when the initial join would already be just the subset of people you cared about anyway.
It's not having what you want - It's wanting what you've got.

