Adam K Dean

Posts

Excel Formula - Nice Currency!

Published 26 January 2011 in archive with tags microsoftexcel I hate it in Excel when my currency has to be either spaced out nicely OR red when negative. There is the currency, which has nice colours, for negatives, which is good. But then the accounting format has nice spacing, with the pound sign on the left. Continue reading …

MySql Version "Correlated Sub-Queries and Group By Unions"

Published 20 January 2011 in archive with tags sql If you look at this SQL article [old link removed], you may either be impressed or insult me for bad coding practise. FYI, it does run on 1000 rows in < 1 second. When I was using MsSql (before I migrated to CentOS/Mono/MySql) I sometimes had to go to extortionate amounts of effort to get stuff done, but with MySql it all seems, a bit too easy.. So from the giant SQL that you saw in the previous article, I can do all that on the same tables (bar one change) with the following SQL: Continue reading …

New String.Format for C - strrep2

Published 14 January 2011 in archive with tags c Following on from the problems I had with my previous string.format C function, I decided to rewrite it today under heavy valgrind observation. Continue reading …

Uri to Hostname in C (GNU-C99)

Published 13 January 2011 in archive with tags c Another C function which works quite well and has no bugs that I know of yet... Continue reading …

Fixed String.Format in C (GNU-C99)

Published 12 January 2011 in archive with tags c I have fixed my strrep string replace function, for now, as there was a bug with using atoi. Continue reading …



Newer Page 37 of 42 Older