如何在TSQL中优雅地比较同一个表中的值

I've got a settings table constructed with 'category' determining different products, 'varname' being the variable name, and 'info' being the value of the setting. I've got a settings table constructed with 'cat