Database

Pete O`Hanlon wrote:

Is this a SQL Server 2005 table?

Pete O`Hanlon wrote:

and I'll see if I can put an example together for you.

WITH TaskSearch (TaskID, TaskName, TaskParent, Level)
AS
(
  SELECT ID, Task, ParentTaskID, 0 AS Level
  FROM Tasks WHERE ParentTaskID IS NULL
  UNION ALL
  SELECT ID, Task, ParentTaskID, Level + 1
  FROM Tasks 
  INNER JOIN TaskSearch 
  ON TaskID = ParentTaskID

)

SELECT TaskID, TaskName, TaskParent, Level
FROM TaskSearch

Pete O`Hanlon wrote:

Sorry - I've done this from memory so it might not be 100%.

dptalt wrote:

Can I delete one of the sets?

Select LAST_TRAN_DATE = Max([Date])
From(
   Select [Date] = LastDDTxn
   From UserHistory
   Union
   Select [Date] = LastCardTxn
   From UserHistory
) Dates

SELECT LAST_TRAN_DATE =
   (CASE
       WHEN LastCardTxn > LastDDTxn THEN LastCardTxn 
       <s>ELSE</s> WHEN LastDDTxn > LastCardTxn THEN LastDDTxn
       ELSE NULL
   END) AS Last_Tran_Date
FROM USERHISTORY