Database

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

yamunasenthilvel wrote:

how to delete a record from the databaseb using ado

CString sql = "DELETE * FROM tbl_Name WHERE col =’value’"

// ADO DB connection
pConnection.Execute(sql.AllocSysString(), NULL, adExecuteNoRecords);

imsathy wrote:

muliple option from a drop down

imsathy wrote:

to the stored procedure as string

string value = MyDropDownList.SelectedValue;
SqlCommand cmd = new SqlCommand(myConnection, "StoredProc");
cmd.CommandType = CommandType.StoredProcdure;
cmd.Parameters.Add("@paramName", value);
SqlDataReader reader = cmd.ExecuteReader(); // Assumes connection is open.

imsathy wrote:

then pass the values to the conditional clause of the procedure

CREATE PROCEDURE dbo.StoredProc
@paramName varchar(100)
AS
SELECT * FROM SomeTable
WHERE someColumn = @paramName
GO