Showing posts from October, 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,'ÁŽ','Î')

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: