Database

CREATE TABLE Types (
       TypeID INTEGER PRIMARY KEY
     , TypeInfo CHAR(125)
);

CREATE TABLE Templates (
       TemplateID INTEGER PRIMARY KEY
     , TemplateSignature CHAR(125)
);

CREATE TABLE Files (
       FileID INTEGER PRIMARY KEY
     , Path CHAR(255)
);

CREATE TABLE Symbols (
       Id INTEGER PRIMARY KEY
     , Kind INTEGER
     , Name CHAR(125)
     , FileID INTEGER
     , TypeID INTEGER
     , Offset INTEGER
     , LineNumber INTEGER
     , TemplateID INTEGER DEFAULT 0 NOT NULL
     , Parent INTEGER DEFAULT 0
);

CREATE TABLE Functions (
       FuncID INTEGER PRIMARY KEY
     , Signature CHAR(125)
     , SymbolID INTEGER
     , ReturnTypeID INTEGER NOT NULL
);

select symbols.name,functions.signature from symbols, functions where
  functions.symbolid = symbols.id;

class AClass {<br />
  string name;<br />
  int offset;<br />
  ...<br />
}

CLASS AClass TABLE CLASSES<br />
  PRIMARY_KEY name<br />
;<br />
<br />
CLASS AUnion TABLE UNIONS<br />
  PRIMARY_KEY name<br />
;

  // oid below can be built dynamically using program variables<br />
  Object oid = ObjectId.createObjectId("AUnion;name=someUnion");<br />
  AUnion myUnion = njdx.getObjectById(oid, true, 0, null);

jszpila wrote:

As perviously mentioned the query is huge so I'd like to avoid using a union if at all possible, just to reduce clutter

SELECT dateColumn, 
       ABS(DATEDIFF(minute, dateColumn, @distanceFromThisTime)) AS TimeDifference,
       CASE WHEN dateColumn IS NULL THEN 0 ELSE 1 END AS Nothing
FROM myTable
ORDER BY CASE WHEN dateColumn IS NULL THEN 0 ELSE 1 END DESC, 
         ABS(DATEDIFF(minute, dateColumn, @distanceFromThisTime)) ASC

jszpila wrote:

My results along these lines (I'm doing some formatting in the SQL - I'm doing the formatting independently with an alias so I don't think it would be messing it up):
01/26/06
01/18/06
01/31/06
01/13/06
02/10/06
12/31/05