asked on
and / or logic in where clause
how would I update the code to grab: Effective or Term within the last 7 days OR last update within last 7 days with effective or term date prior to the last 7 days?
WHERE ek.OrderId = 'rty5465464'
AND (
ek.termdate
BETWEEN GETDATE() - 7 AND GETDATE()
OR ek.effdate
BETWEEN GETDATE() - 7 AND GETDATE()
OR
ek.lastupdate
BETWEEN GETDATE() - 7 AND GETDATE()
* T-SQLMicrosoft SQL Server
Last Comment
Bill Prew
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It looks like your code is returning values where term and effective date is null
ASKER
actually not. I was wrong about the nulls
can you pls provide few input rows and the expected output.
ASKER
ty
Welcome.
»bp
»bp
2017-11-01 00:00:00