I'm not sure if you have explored this option or if it would be any better of what you've already got.

IF OBJECT_ID('tempdb..#Files') IS NOT NULL DROP TABLE #Files;

CREATE TABLE #Files(...

drew.allen (6/11/2015)

---

Luis Cazares (6/11/2015)

---

I can't assure that it's faster or better. The only way to ensure that is...

Any reason to that?

I can't assure that it's faster or better. The only way to ensure that is by testing over...

Change the tables so they can be temp tables https://technet.microsoft.com/en-us/library/ms177399(v=sql.105).aspx

Or table variables.

I'm giving an example on how you should post your data. As you see, the code can be copied and ran without any major effort.

I'm including a possible solution with...

I would encourage you to change the way you write JOINs. That syntax is the old way and can become confusing with more complex queries and develop into unwanted cartesian...

Some basic things here, probably we're missing something.

Your declaration of the cursor uses 1 variable and you only use the column on that variable within the cursor.

Basically, your code should...

Do you mind if I join the party?

SELECT n.NewsId

FROM #NewsEntities n

WHERE EntityId = 1

EXCEPT

SELECT n.NewsId

FROM #NewsEntities n

WHERE EntityId = 2

Gail Shaw has a series of articles on her blog where she tests this options. This specific test is done here: http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

However, I would insist on following Phil's advice on...

doug.davidson (6/11/2015)

---

+1

Figured it out by elimination:

1000 - wrong

220 -...

Change the SELECT * to specify all the columns needed and generated after the pivot. Change the ISNULL to those columns.

Or you could read the following article and learn how to do it yourself, either with pivot or cross tabs.

http://www.sqlservercentral.com/articles/T-SQL/63681/

Ed Wagner (6/4/2015)

---

rodjkidd (6/4/2015)

---

Lynn Pettis (6/4/2015)

---

Alvin Ramard (6/4/2015)

---

Jeff Moden (6/4/2015)

---

Shifting gears a bit...

Have any of you ever used a CTP of SQL Server to power your real production databases? ...

It might not relate to the question directly, but if the number will be stored, this could be an alternative.

CREATE TABLE #Increments(

id5 int IDENTITY(5,5),

...