DougG (2/6/2013)

---

ChrisM@Work (2/6/2013)

---

T.Target isn't one of the numeric datatypes. You're only trapping one string value from being bassed in to the function, are you sure there are not more? Have...

There's no point in thrashing the horse when someone's left the cart brake on...

T.Target isn't one of the numeric datatypes. You're only trapping one string value from being bassed in to the function, are you sure there are not more? Have you tried...

nick.mcdermaid (2/6/2013)

---

I did try running just the SELECT query early on in the piece and also when I was trying to get the Actual plan. In both cases I stopped...

dwain.c (2/6/2013)

---

Had a few minutes spare before a meeting. See that fish in your avatar? I'd like to fry it for...

Of course...but when was the last time you tried to run just the SELECT...

DECLARE @Shifts TABLE

(staffid int, shiftdesc varchar(20), shiftdate datetime, shifthours float)

INSERT INTO @Shifts

SELECT 1, 'Sick', '2012-02-01', 8...

nick.mcdermaid (2/6/2013)

---

OK I extracted what I think is the actual plan from sys.dm_exec_query_plan and it was identical to the estimated one that I uploaded, so we can assume the uploaded...

That plan S a RA, T&S.

Out of interest, try this, and please post the actual plan:

SELECT DT.MO_OF_YR_NM ...

That's because it's a CREATE TABLE script, with CREATE changed to ALTER. You will need to be more specific and respect the rules of the command you wish to use....

Steven Willis (2/5/2013)

---

Just a generic observation...

If this function is taking two hours to run--even with all of the cursors and subcursors--then you are probably accessing a LOT of data. I...

No less than four levels of nested queries! Good Lord, no wonder it takes so long. Examining the code, none of it, even the few queries, look as if they've...

Or this:

SELECT

T1.IDCUST,

T1.IDINVC,

T2.AMTPAYM,

TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)

FROM MyTable1_ARIBH T1

INNER JOIN MyTable2_ARTCP T2

ON T2.IDCUST = T1.IDCUST

AND T2.IDINVC = T1.IDINVC

WHERE T1.IDCUST =...

Do you have a question?

Abrupt! How about a source?