SQL query using equal or not equal to

>Where (( aa . new_evidenceforoutputidname in ( 'Starts On Scheme (post)' ))
and ( aa . new_evidenceforoutputidname not in ( 'Pre-Start Assist' , 'Business Starts' ) )

The above can be replaced with:

Where aa.new_evidenceforoutputidname ='Starts On Scheme (post)'

Give us more details.

---

Kalman Toth Database & OLAP Architect SQL Server 2014 Design & Programming

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012