GonnaCatchIT (6/16/2015)

---

Hi Team,

Below query is taking over 2.5 minz due to which we are getting timeout.

SELECT PPS.No, PPS.PID, PPS.Date,

PPS.Amnt1 + PPS.AMNT2 + PPS.Amnt3 - ISNULL(PPSL.Amnt4,0) + PPS.Amnt5

AS Amnts

FROM...

rodjkidd (6/16/2015)

---

ChrisM@Work (6/16/2015)

---

rodjkidd (6/16/2015)

---

ChrisM@Work (6/16/2015)

---

I sent the link around the lads here. One...

rodjkidd (6/16/2015)

---

ChrisM@Work (6/16/2015)

---

I sent the link around the lads here. One of them...

rodjkidd (6/16/2015)

---

ChrisM@Work (6/16/2015)

---

I sent the link around the lads here. One of them...

I sent the link around the lads here. One of them sent the...

dwain.c (6/16/2015)

---

rodjkidd (6/16/2015)

---

From the comments;

Q: And where's TARDIS?

A: It's both too large and...

koles2004 (6/12/2015)

---

I have such Function:

IF EXISTS (SELECT * FROM sys.objects WHERE name = 'TwoDigitsNumber' AND type = 'FN')

DROP FUNCTION MinimumOFThree;

GO

CREATE FUNCTION TwoDigitsNumber(@a int)

RETURNS nvarchar(20)

AS

BEGIN

DECLARE @str nvarchar(20);

DECLARE...

Your programmer is learning his trade...

-- Style 112 for the convert function is 'yyyymmdd' which doesn't match the supplied string.

-- The CONVERT function doesn't make sense anyway - you're converting a string to a string.

--...

T2512 (6/12/2015)

---

Thank you for the reply!! the execution plan has real table names, which is why i did not post the full plan earlier. The image attached is the...

-- Please check that this formatted version of your query still works,

-- then put table aliases before each column reference in the

-- inner derived table 'r'.

SELECT DISTINCT *...

Can you attach an actual execution plan as a .sqlplan attachment please? Each graphical component on the plan has a whole bunch of properties which provide essential clues for query...

Please post the execution plan as a .sqlplan attachment, not...

jeff.born (6/11/2015)

---

SSCertifiable,

I've been playing with the cross apply and trying to get it to work with a few other requirements. Each business group I should easily be able to...

-- It's not clear what you want as your output because you decribed it (badly)

-- rather than presenting it as data.

-- This might be correct, then again, it...