In an empty, sandbox database try the following. By the way, your view needs to be reworked but to do it right we need to see the full DDL...

Obviously you did not read the article you were asked to read. The table definitions and sample data posted are unusable unless one takes the time to write it...

Second (and before you tell you can't I provided SQL Server database support for a PeopleSoft development/support team at a previous employer for five years and I know what is...

First, I reformatted your code. I was able to determine that you are joining the two tables on 24 columns. Not really having time to work through the...

rajsin7786 (8/4/2014)

---

Ran the amended SQL but there is still no improvement. it takes exactly the same time (50 minutes) to run. Have attached the actual execution plan, looks exactly the...

I am taking a guess, but something like this:

-- Setup sample table a and data.

create table #TestData(

ContractNumber int,

StartDate date,

...

Actually, I think the Crystal Ball is needed here. I just wanted to...

New_2SQL (8/3/2014)

---

Hi Lutz,

As my nickname describes, I am very new to the forum and to SQL, so please do not get upset. Maybe I have to learn how to post...

Being a visually oriented person, I'd need to see what the OP is expecting the results to be from the query.

Evil Kraig F (8/1/2014)

---

Lynn Pettis (8/1/2014)

---

You could also use a system variable to contain the same information regarding the location of configuration files. We went with the XML file...

Daniel Matthee (8/1/2014)

---

Hi

Although the above mentioned queries will work I have learned not to do Inner select as this creates over head on the tempdb on the server.

An inner select...

At a previous employer we established a fixed directory on the c: drive of our development and production Data Warehouse servers. This fixed directory contained an XML configuration file...

solomon.jernas (8/1/2014)

---

we are getting errior in event viewer, "Cannot be performed write operation in the database" so the application has hunging statge.

After that bring the database to offfline then online,...

And this is why I like SSC. The question was answered and several alternatives and improvements to process were provided. Even a minor change to the last piece...

John Mitchell-245523 (8/1/2014)

---

You certainly don't need a cursor, as others have shown you. However, may I suggest you approach this from a different angle? It's all very well...