Category Archives: SQL

SQL Language Assistance

Maximo Hierarchies Report

Posted on 2014-01-22 by QASuper

I went through several options on making Location Hierarchy Reports, and found these queries to be quite beneficial. The code is different, depending on the backend being Oracle or Microsoft. Oracle select level, lpad (‘ ‘, 8 * (level – … Continue reading →

Posted in Maximo, Maximo-5, Maximo-6, Maximo-7, Oracle, SQL, SQL Server (M$) | Comments Off on Maximo Hierarchies Report

SQL Server Named Instance Port

Posted on 2011-09-29 by QASuper

When you need to connect to a SQL Server that has a Named Instance, and your application is not capable, don’t lose hope. You can find the PORT for the named instance in the Windows Registry under: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[Instance … Continue reading →

Posted in SQL Server (M$) | Comments Off on SQL Server Named Instance Port