How to fix strange Windows 7 Update errors

1. Run System Update Readiness Tool

2. Check log-file C:\Windows\Logs\CBS\CheckSur.log

3. For me it stated
Unavailable repair files:
    winsxs\manifests\amd64_microsoft-windows-trapk_31bf3856ad364es5_6.1.7600.1638w_none_b67f949fad92001b.manifest
    winsxs\manifests\amd64_microsoft-windows-capi2-certs_s1bf3856ad364e35_6.1.7600.16385_none_1e83acdeaddva038.manifest

4. Start Windows Update (also [!] if it fails – important for the next step; the HKLM->Components hive is loaded by doing so)

5. Start regedit

6. navigate to HKEY_LOCAL_MACHINE\COMPONENTS\DerivedData\Components\ and search for (in my case) amd64_microsoft-windows-trapk_31bf3blahblahblah

7. export the keys

8.  delete the keys

9. try to update Service Pack 1

Separate column in two columns Oracle and output as HTML

(Representation, business logic and data layer should really be separated! Because of this this statement sucks.)

http://www.sqlfiddle.com/#!4/d998f/8

CREATE TABLE YourTable
  (Column1 int, Column2 varchar(1))
;

INSERT INTO YourTable VALUES(1, 'a');
INSERT INTO YourTable VALUES(2, 'b');
INSERT INTO YourTable VALUES(3, 'c');
INSERT INTO YourTable VALUES(4, 'd');
INSERT INTO YourTable VALUES(5, 'e');
INSERT INTO YourTable VALUES(6, 'f');
INSERT INTO YourTable VALUES(7, 'g');
INSERT INTO YourTable VALUES(8, 'h');
INSERT INTO YourTable VALUES(9, 'i');
INSERT INTO YourTable VALUES(10, 'j');

SELECT '' || listagg(htmlRow) within group (order by null) || ''
FROM
(
  SELECT '' || MAX(CASE WHEN mcol = 0 THEN legendcell END) || '' || MAX(CASE WHEN mcol = 1 THEN legendcell END) || '' AS htmlRow
  FROM 
  (
    SELECT 
      (CASE WHEN t1cRowNumber>t2cDivider then t1cRowNumber-t2cDivider else t1cRowNumber end) as mrow, 
      (CASE WHEN t1cRowNumber>t2cDivider then 1 else 0 end) as mcol, legendCell 
    FROM 
    ( 
      SELECT 
        t1cRowNumber, 
        TRUNC(t1cRowCount / 2) + mod(t1cRowCount, 2) as t2cDivider, 
        legendCell 
      FROM  
      ( 
        SELECT 
          ROWNUM AS t1cRowNumber, 
          COUNT(*) OVER () as t1cRowCount, 
          legendCell 
        FROM 
        ( 
          SELECT 
            (Column1 || '' || Column2) as legendCell 
          FROM 
            YourTable 
          WHERE 
            Column2 IS NOT NULL ORDER BY Column2
        ) legend 
      ) t1c
    ) 
  )  
  GROUP BY mRow  
  ORDER BY mRow 
)

Recursively ping server until it is back online

@setlocal enableextensions enabledelayedexpansion
@echo off

set ipaddr=localhost
:: The next variable refers to the Windows version "language" for example en->Received or de->Empfangen
set receivedAlias=Received

:loop
for /f "tokens=5,7" %%a in ('ping -n 1 !ipaddr!') do (
if "%%a"=="!receivedAlias!" if "%%b"=="1," goto :end
)
clear
echo Still down.
goto :loop

:end
mshta javascript:alert("Back online!");close();

Lazy Lookup mapping

Can be used to cache values from database

     private static Lazy<Lookup<string, string>> MyMappingLookup = new Lazy<Lookup<string, string>>(() =>
        {
            using (var session = SessionFactory.GetSession())
            {
                var result = session
                                .CreateSQLQuery("select foo, bar from whatever where bananas")
                                .List<object[]>()
                                .ToLookup(
                                    values => values[0].ToString(),
                                    values => values[1].ToString(),
                                    StringComparer.OrdinalIgnoreCase
                                );

                return (Lookup<string, string>)result;
            }
        });

        private static string CheckOrConvertBanana(bool convert = false)
        {
            var code = "red_pyjamas";

            if (string.IsNullOrEmpty(code) || !MyMappingLookup.Value.Contains(code))
            {
                // not found, warning...
            }
            else
            {
                if (convert) code = MyMappingLookup.Value.First();
            }

            return code;
        }

.NET: Microsoft Unity – Strange error message

Having this error?

English:
The non-generic method 'Microsoft.Practices.Unity.IUnityContainer.Resolve(System.Type, string, params Microsoft.Practices.Unity.ResolverOverride[])' cannot be used with type arguments

German:
Methode 'Microsoft.Practices.Unity.IUnityContainer.Resolve(System.Type, string, params Microsoft.Practices.Unity.ResolverOverride[])' ist nicht generisch und kann daher nicht mit Typargumenten verwendet werden.)

Try adding “on top”:
using Microsoft.Practices.Unity;