select

t1.id

,t1.timestamp

,t2.timestamp

,TimeTaken = cast(datediff(second,t1.timestamp,t2.timestamp)/3600 as varchar)+':'

+right('0'+cast(datediff(second,t1.timestamp,t2.timestamp)/60 %60 as varchar),2)+':'

+right('0'+cast(datediff(second,t1.timestamp,t2.timestamp) %60 as varchar),2)

from dbo.runningtime t1

left join dbo.runningtime t2 on t2.id = t1.id+1

Here's another attempt.

@dba-2 From The Cold, I don't mean to...

Voted.

Arrest

Thanks Gail.

It's hard to ask why they want things because of the dark politics of what's going on. We have to keep things very much at arms length so...

I wondered if it's to handle timespans. What we're doing is heavily connected to lengths of time and the duration of various things. I could understand if they...

HanShi (11/20/2014)

Stuart Davies (11/20/2014)

Koen Verbeeck (11/20/2014)

This means people have to vote for me (or other people, but preferable...

fugue

I stand corrected. There are several companies that offer pre-employment credit checks over here. The thinking is to avoid the possible corruption. One company also phrases it in...

Stefan Krzywicki (11/18/2014)

cackalackian (11/18/2014)

Would you want aspects of your life, perhaps data outside of your health (think driving, finance, etc) to be part of the evaluation (or negotiation) process for...

Give this a try

create function dbo.ProperCase (@name varchar(70))

returns varchar(70)

as

begin

declare @output varchar(70)

declare @upper varchar(70)

declare@space int

declare @first varchar(70)

declare @last varchar(70);

set @upper= rtrim(ltrim(upper(@name)))

set @space= patindex('% %',@upper)

set @first= left(@upper,@space)

set @last= reverse(left(reverse(@upper),@space) )

set @output =...

The short answer is yes, the long answer is 'it depends what for'.

http://msdn.microsoft.com/en-us/library/ms144275.aspx

Thanks Perry, I spent most of yesterday looking into the column source and destination mappings as you suggested but I'm still struggling. From what I found, I got the...

Stuart Davies (11/11/2014)

BWFC (11/11/2014)

One of the people whose name I've seen attached to the kitchen cabinets spam lives just down the road from me. He's a reasonably notorious local businessman who's actually...

I suspect not as many people will get this right as they should because one of the two identical options returns a wrong answer.