The Problem A client sent me an excel sheet with financial information classified in columns where each column header was a date and the values associated with that date were listed below I needed to insert the information to a normalized table with the following columns: Client Account EntryDate Value The Solution Step 1 Loaded … More Transact-SQL Server – Transposing a table
The obligatory reflection on what have we accomplished in 2015 … always a sticky question. But if keep it to my book, training and research, it does not look that bad, I managed to keep the momentum going. Software Development Cracking the coding Interview – Gayle Laakman This is a great book with brain teasers and … More Books every software developer should read in 2016 – if you have not done so
I am a member of the board of directors for a non-profit. Since last year I have intermittently receiving emails, as the treasurer of the organization, it would like to see emails, specially those that require my attention. Long story short, the email administration fell on my lap and tired of people giving me funny … More cPanel Mailing Lists Not Delivering Emails
Registering .Net Dlls’ for use in VB6 32 or VBA applications You have that legacy application that is not willing to go away and you need to use functionality from code you created in .Net. or you need to build extra functionality on a .Net classYou need to register the dll for VB6/VBA to be … More Registering .Net DLLS’ for use in VB6 32bit Applications