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]...

ramrajan (2/11/2015)

---

The below query taking very long time to up few records also,

Can anyone please rewrite this query for good performance with INNER joins.

SELECT

...

Debbie Edwards (2/11/2015)

---

Hi,

I have come across a niggle that I cant seem to resolve.

I have a number field and my report is ordered against it. However, When I looked I...

New Born DBA (2/6/2015)

---

I have this SQL statement with 2 different execution plan. I am also attaching both execution plan. No one has complained about the performance yet. Just curios...

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus, javelin). It...

Grant Fritchey (2/5/2015)

---

ChrisM@Work (2/5/2015)

---

Grant Fritchey (2/4/2015)

---

SQLRNNR (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot...

Grant Fritchey (2/4/2015)

---

SQLRNNR (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus, javelin)....

dwain.c (2/4/2015)

---

Quite interesting.

This illustrates the problem.

CREATE VIEW dbo.Test

WITH SCHEMABINDING

AS

SELECT

RecordLastChangedDateKey=20150204,

x=CAST('20150204' AS DATE) ;

GO

CREATE UNIQUE CLUSTERED INDEX IDX_t1 ON dbo.Test (RecordLastChangedDateKey, x);

GO

SELECT *

FROM dbo.Test;

GO

DROP VIEW dbo.Test;

Perhaps this solves it?

CREATE VIEW dbo.Test

WITH...

Byzza (2/3/2015)

---

I'm sure this is by far not the best way to do things, buts its been the only way I've worked out so far.

I have 2 tables - 1...

theboyholty (2/4/2015)

---

Thanks but its still giving me the message "The view contains a convert that is imprecise...

theboyholty (2/4/2015)

---

I'm trying to create an indexed view. In my table there are 5 dates, all integers in their native form e.g. 20150204. I want to out put this in...

SELECT

d.Fullname,

Lastname = LEFT(d.Fullname, pos1-2), -- -2 removes the comma, could use REPLACE

FirstName = SUBSTRING(d.Fullname, pos1+1, (pos2-pos1)-1),

MidddleName = SUBSTRING(d.Fullname,pos2+1,8000), -- could use REPLACE to remove period

x1.*, x2.* -- included...

-- Before attempting to fix the results set of your query,

-- you might want to do some remedial work on the components of it.

-- Here's a little sample set...

It's easy once you've worked through your first example. Here's another article written by Jeff Moden:

http://www.sqlservercentral.com/articles/Crosstab/65048/%5B/url%5D

A couple of minor changes to your query which may make the job easier:

SELECT --...

Resender (2/2/2015)

---

ok this is something of a best practice of mine in my queries

I always do

WHERE 1 = 1

I can't remember where I picked this habit up and I'm one...