Database

imranafsari wrote:

select datediff(d , '2008-09-01' , '2008-09-05')

SELECT DATEDIFF(minute, start.Date_TimeWorked, end.Date_TimeWorked) AS ElapsedMinutes
FROM TableName start,
     TableName end
WHERE start.ID = end.ID
AND   start.Status = 'Ready'
AND   end.Status = 'Completed'

...
FROM WorkData start,
     WorkData end
...

SELECT DATEDIFF(minute, readyRow.Date_TimeWorked, completedRow.Date_TimeWorked) AS FromReadyToCompleted,
       DATEDIFF(minute, readyRow.Date_TimeWorked, rejectedRow.Date_TimeWorked)  AS FromReadyToRejected
FROM TableName readyRow 
        LEFT OUTER JOIN
     TableName completedRow
        ON readyRow.ID = completedRow.ID
        LEFT OUTER JOIN
     TableName rejectedRow
        ON readyRow.ID = rejectedRow.ID
WHERE readyRow.Status     = 'Ready'
AND   completedRow.Status = 'Completed'
AND   rejectedRow.Status  = 'Rejected'

JUNEYT wrote:

He has allready comprimised the server and captured the password and login ID of my database