I've also tried without the "convert(smallmoney,0.03)"
select top 10 c.memberId, m.memberName, convert(smallmoney,newvalue) from changeLog c join members m on m.memberId = c.memberId join members a on a.memberType = 'ALT' and a.retireeId = m.memberId where keyFieldExtra like 'COLA%' and year(changeTime) >= 2014 and convert(smallmoney,newValue) > convert(smallmoney,0.03)
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.