Compare two SQL Tables

I was updating one table with data from another. However, when I did this there was a¬†discrepancy between the number of rows I had in the update table and the number of rows updated. Here the SQL that allowed me to compare and return the rows that were in the source but not the destination.…

Restarting a Computer via Terminal Session

I can never remember the key combo to do a shut down or restart of a remote computer in Terminal Session. So I’m posting this on my online memory board here. Ctrl + Alt + End. Please note unless you have quick access to the computer in question be sure to select Restart instead of…

Trouble removing trailing space in Excel 2010

I could not remove the trailing space in an Excel 2010 column with the Trim() function. Doing a little research led me to believe this might possibly be caused by the space being something other than the ASCII code for space. (Decimal 32). The function I used to find this. =CODE(RIGHT(A1)) It returned a code…