i would like to update my stored procedure, which is ran daily, to only enter current day and 1 day prior. The tsql is doing joins on 4 tables i would like to get the previous days entries along with the current day it is being loaded on a column labled last_update_date.

i have something like this last_update_date >= dateadd(day,datediff(day,1,GETDATE()),0)

however it is still pulling all the historical days which i dont want, because it will create duplicate rows. if the day already exist it should skip over it and only enter current day -1(previous).