If you're sure that all you need is HH:MM:SS, then this will work.

with cte as (

select datediff(second, '09:28:00', '13:38:02') diff)

select

right('00' + convert(varchar(2), (diff % 86400)...

Not that I've seen. Most volunteers open a question, read it, see that it's been...

You...

Horsemen

Grant Fritchey (9/5/2013)

---

Without knowing what's happening inside those UDF's, it's hard to say whether or not it would affect performance. I'm willing to bet money that there's some type of...

Tom - I've seen so many problems caused by with views on views on views in the past that I've denounced them as heretical and will never write them myself....

We figured you were using SQL 2008 since you posted in a SQL 2008 forum.

I believe CTEs were introduced in SQL 2005. Sorry, but I don't have a SQL...

Gatling Gun

This is absolutely the best approach I've seen anywhere for string parsing. It uses a set-based approach instead of parsing through the data set row by row and then...

Sean Lange (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering...

Are the returned data sets the same no matter who runs the query? If you're selecting everything from a TVF, what is that function doing? Does it depend...

WayneS (9/3/2013)

---

Ed Wagner (9/3/2013)

---

Like normal,...

Good question - thank you. It made me go back "a few" years and think about something that most of us take for granted now.

ScottPletcher (9/3/2013)

---

Whatever rules you decide on, you should enforce them programmatically. Otherwise, the rules will be broken and be meaningless.

Also, follow the first rule of naming -- don't build...

This can't be as simple as it appears, so I have to question what is missing. If it really is this simple, just use the SUBSTRING function to concatenate...