Stop digging, Tom! For goodness' sake, you're coming across as a cranky old fella with a short fuse. This is not what we are used to seeing from you.

Matt Miller (#4) (2/12/2015)

---

Jeff Moden (2/12/2015)

---

I'm thinking that the following from the original code could be the real problem here. Dunno for sure because I don't know the data...

Jeff Moden (2/12/2015)

---

I'm thinking that the following from the original code could be the real problem here. Dunno for sure because I don't know the data but it would...

sgmunson (2/12/2015)

---

ChrisM@home (2/12/2015)

---

You're absolutely right Steve, it's an OUTER APPLY coded using CROSS APPLY! I'd love to see some ddl and dml for the tables referenced within it. If the...

Point taken, sorry.

Ok try this: what two columns does the ordinary...

Imagine the...

In this particular case, which of the following statements is the more accurate:

"Write it properly"

"Tune it"

Sometimes it's a fine line, but in this case I think it's clear.

It seems...

Zohaib Anwar (2/12/2015)

---

ChrisM@Work (2/12/2015)

---

The stored procedure is written in a procedural Row-By-Agonizing_Row way indicating an inexperienced programmer. The upside is that you have plenty of scope for improvement by a...

maria.pithia (2/12/2015)

---

Please see my Question as i have clearly stated that i dont want to use create table statement or dont want to set defualt value.

i want to do this...

The stored procedure is written in a procedural Row-By-Agonizing_Row way indicating an inexperienced programmer. The upside is that you have plenty of scope for improvement by a professional. So why...

Zohaib Anwar (2/12/2015)

---

Please let me know if you need any further detail. I Can also provide Trace file if required. please help me its urgent development team is asking ETA...

erwin.oosterhoorn (2/12/2015)

---

Don't worry, I will always test before I implement. This was more a 'gut feeling' and wanted to make sure that other users where not going to take this...

-- t11 partial rewrite. Can't go any further than this without ddl/dml for ClientMember / ClientRole / MemberOther

CROSS APPLY ( -- t11

SELECT TOP (1) [t10].[test]

FROM (SELECT NULL AS [EMPTY]) AS...

I have to disagree with you Dave:

-------------------------------------------------------

-- t4 rewrite

-------------------------------------------------------

-- [t3].[EndEffectiveDate] =...

Here's that same query with a little extra formatting:

SELECT

[t4].[Destination],

[t4].[Message],

[t4].[OutboxAN],

[t4].[OutboxStatusAN],

[t4].[OutboxTypeAN],

[t4].[Subject],

[t4].[Fax],

[t4].[FileName],

[t4].[OutBoxData] AS [OutBoxData1],

[t4].[OutBoxDataAN],

[t4].[Type],

[t4].[ClientReferenceID],

[t4].[value] AS [CompanyClientMemberID],

[t4].[value2] AS [ContactClientMemberID],

[t4].[value3] AS [ReportType],

[t4].[value4] AS [CompanyClientRoleID]

FROM ( -- t4

SELECT

[t0].[Destination],

[t0].[Message],

[t0].[OutboxAN],

[t0].[OutboxStatusAN],

[t0].[OutboxTypeAN],

[t0].[Subject],

[t1].[Fax],

[t1].[FileName],

[t1].[OutBoxData],

[t1].[OutBoxDataAN],

[t1].[Type],

[t0].[ClientReferenceID],

[value] = ISNULL([t0].[CompanyClientMemberID],@p1),

[value2] = ISNULL([t0].[ContactClientMemberID],@p2),

[value3] = ISNULL([t0].[ReportType],@p3),

[value4]...