Have you considered changing your splitter function to a faster one?

Here's probably the fastest available: http://www.sqlservercentral.com/articles/Tally+Table/72993/

aziznet (8/19/2015)

---

I have data concerning sale of several products, columns are number of customer, date of purchase and name of product.

I need to calculate with SQL the average duration...

Johnny

People seem to be forgetting the aggregation. I hope that you're doing this to move out of this horrible design that will only create headaches.

SELECT AttribName,

CASE...

TheSQLGuru (8/18/2015)

---

Ken at work (8/18/2015)

---

I'm not sure...

As mentioned, the format YYYYMMDD will automatically convert to datetime without the need...

This was the option that I mentioned yesterday, but I had to get out of the office and couldn't post it.

It will replace any number of instances and has the...

SQL Server doesn't allow user defined functions with variable parameters. All the parameters must be included every single time. There could be an option if you would take 2 strings,...

Here's one with the same functionality but as an inline table valued function.

CREATE FUNCTION dbo.iDateSerial

(

@year int ,

@month int ,

@day int

)

RETURNS TABLE

AS

RETURN

...

Eric M Russell (8/18/2015)

---

Jeff Moden (8/18/2015)

---

Alan.B (8/17/2015)

---

Jeff Moden (8/14/2015)

---

Alan.B (8/14/2015)

---

BobAtDBS (8/14/2015)

---

I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do...

If you ask me, I would rewrite the query like this even if it's not exactly what you have right now:

SELECT TE.JobID,

TotalDistanceTravelled as Distance,--convert(varchar(30),TotalFare) as TotalFare,...

I hope that you're not using the triangular joins methods as they're very slow. If you want to know the reason, it's explained in here: http://www.sqlservercentral.com/articles/T-SQL/61539/

For the cursor option, you...

Contractor

In 2012+ versions, you can use the OVER() clause for this.

In 2008 and previous versions, there are different methods which are fully explained in here along with a performance comparison:

http://www.sqlservercentral.com/articles/T-SQL/68467/

The amazing part is that this same poster was in charge of a 2005 to 2012 migration. :w00t: