really new to SQL so if my question is stupid or complicated, sorry, but i need to run 2 parameters. We have a vendors that are on hold or active and contract date expiration. I need to pull the report for all on hold vendors, but only those active that contract expiration date is more than 360 days away from today's date. I can run 2 reports, but would like to put together a report that will not have to be altered or corrected in the future. the code i have below works, but the date parameters apply to both, active and on hold, how do i change it so that the date only applies to active and all on hold show up. Hope i didn't confuse anyone and thanks in advance.
d.VendorRelationStatus in (‘Active’,’On Hold’)
AND d.ContractEndDate > getdate() AND d.ContractEndDate >= dateadd(d, +360, getdate())