I am attempting to write a simple WHERE but it's not returning my results even though I know for certain the values are there. In query below, I expect to get the 2 rows returned but it isn't. Ughhh... it's so frustrating.
from #temp1 a
where (a.CustomPropertyName = 'Capitalization'
and a.CustomPropertyValue = 'Small-Cap EQuities')
and (a.CustomPropertyName = 'BASAllocation'
and a.CustomPropertyValue = 'Large-Cap Equities')
Expected Output Based on the WHERE clause above;
Symbol Name PropertyName PropertyValue
cop ConocoPhillips Capitalization Small-Cap Equities
cop ConocoPhillips BASAllocation Large-Cap Equities