Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
create table #TreatmentData( PatientId nvarchar(18), TreatedWith nvarchar(30) );
Patients can have any combination of treatments but i am only interested in those that have had "A" and "C"
PatientId TreatedWith 1 A 2 A 3 B 1 C 2 C 4 E 4 E 1 B
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.