keschuster
asked on
SQL Question
I'm trying to figure out this query for SQL Server
My table has records that are inserted as follows
note process start stop
note1 myprocess 8/4/2016
note1 myprocess 8/5/2016
I want to group the two records on Note and Process and return a date difference between Start and Stop
Returned
Note Process DateTimeDiff
note1 myprocess 1
help?
My table has records that are inserted as follows
note process start stop
note1 myprocess 8/4/2016
note1 myprocess 8/5/2016
I want to group the two records on Note and Process and return a date difference between Start and Stop
Returned
Note Process DateTimeDiff
note1 myprocess 1
help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.