Try thie:

with testdata as ( -- this cte is only used to provide the test data for the code below

select

cast(stuff(dt.MyTime,8,1,'.') as time) MyTime

from

(values ('0:12:14:124'),('0:08:16:361'),('0:08:57:705')) dt(MyTime)

)

select

...

Try printing out the sql code before you execute it. You may find the problem there. Nothing in the code provided can help as it looks like it...

CELKO (9/3/2012)

---

You gave us no DDL, so this will be harder than it should. I assume that you want to get rid of this function. Good SQL never use them;...

Not having anything to test with, this is a possible alternative that converts your multi-statement tvf into an inline tvf. Test it out and compare it to what you...

Sean Lange (9/4/2012)

---

Lynn Pettis (9/4/2012)

---

Sean Lange (9/4/2012)

---

If performance is a concern you should take a look at the link in my signature about splitting strings. Depending on what you are...

Not sure where you get the idea that anything hurts. Just trying to...

Sean Lange (9/4/2012)

---

If performance is a concern you should take a look at the link in my signature about splitting strings. Depending on what you are using for a splitter...

Missed the draft. I was walking the South Rim of the Grand Canyon with my daughter and one of her friends.

I need to see what my team looks like.

ananda.murugesan (9/4/2012)

---

Hi,

what could be issues as below records for mirror server? It is showing time to send INFINITE

Time Recorded

Role - Mirror

Mirror - Synchronized

UnusendLog - 611 KB

un restoredLog - 0 KB

Time...

The skeleton you show us is an inline table valued function.

sivajii (9/3/2012)

---

here i used CROSS APPLY dbo.DelimitedSplit8k(@VALUES,'')ds funtion to split the words 'the cri word'

declare @value varchar(800)='the cri word'

function ...

sivag,

For your informantion, we are volunteers on this site providing help to others as part of giving back to the SQL Server community.

We are willing to help you, but you...

Try unioning the data first, then aggregating it all. Look up CTE's and/or derived tables. I would do more but I need to hit the road as I...

Modify as needed for your site:

SELECT

DATEADD(dd, 0, DATEDIFF(dd, 0, createdate)) AS createdate,

COUNT(DATEADD(dd, 0, DATEDIFF(dd, 0, createdate))) AS totalcount,

sum(case...

Your query returns nothing from the sample data provided.