Saturday, October 31, 2015

Tidy badly encoded DB TABLE french chars

These few SQL lines came in handy when wanting a quick-fix for a poorly imported table

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á©','é')

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á´','ô')

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'ÁŽ','Î')

Thursday, October 1, 2015

Home Truths


Had to pinch a couple of these






And one I could not find….   There is a graph showing how much as a percentage a programmer thinks a project is completed, vs how much its actually completed.


If someone knows where I can find this graph  - please let me know.    Here is the rough idea: