update #Sample_2019 set Date_Of_Service = a.DOS
from ( Select Unique_ID, MIN(DOS) as DOS
From #Sample_2019 a
inner join [dbo].[MainTable] b on Unique_ID1 = b.Unique_ID
group by Unique_ID
) a
asked
Hi I'm trying to update a column with MIN(Date) based on distinct IDs. When I execute it updates all columns to same MIN(Date). I need it to add the different MIN(Date)s based on the unique IDs. Thanks in advance
update #Sample_2019 set Date_Of_Service = a.DOS
from #Sample_2019 targetTable
JOIN ( Select Unique_ID, MIN(DOS) as DOS
From #Sample_2019 a
inner join [dbo].[MainTable] b on Unique_ID1 = b.Unique_ID
group by Unique_ID
) a ON targetable.Unique_ID = a.Unique_ID
It worked! thanks!
17 People are following this question.
