Ed Wagner (8/11/2014)

---

GilaMonster (8/11/2014)

---

paul.knibbs (8/11/2014)

---

Jeff Moden (8/9/2014)

With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia,...

Koen Verbeeck (8/15/2014)

---

GilaMonster (8/15/2014)

---

However OP said

So, no row number, no temp tables....

serviceaellis (8/15/2014)

---

JeeTee (8/15/2014)

---

If MemberTypeID 2 is all you care about, you can simply omit the lines of code from Eirikurs example that reference MemberTypeIDs you don't care about.

Is this for...

You can try out these methods as previously suggested, hard to understand why going through all the trouble instead of using ROW_NUMBER!

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @RESSET TABLE

(

...

Look into the MAXIMUM DEGREE OF PARALLELISM and COST THRESHOLD FOR PARALLELISM[/url] settings.

😎

My bad, sorry for the incomplete answer;-)

The complexity of not using an aggregate is...

It is of course possible on almost static databases with mostly reads and hardly any inserts/updates, but in general it is unlikely. There may be other reasons where one would...

Quick thought, you might want to use cross-tab instead of pivot, take a look at this article by Jeff Moden, Cross Tabs and Pivots[/url]

😎

It is SSMS which is playing tricks on you, for an automatic process it should not be in the picture. Create a stored procedure with your select statement and call...

sandie_zarate (8/14/2014)

---

If our processes run every 2 minutes on 3 DBs simultaneously, everything is fine... why are we encountering problems if we run our processes every 2 minutes on more...

It is obviously the keyboard:-P

There are so many possibilities here that it's hard to say where to start. First thing is probably the laptop's power management, make certain it is...

SQLRNNR (8/14/2014)

---

Eirikur Eiriksson (8/14/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77...

Lynn Pettis (8/14/2014)

---

Eirikur Eiriksson (8/14/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for...

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have...

Quick thought along with previous suggestion, selecting with a conversion will still return the rows up to the conversion failure, here is an example code

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_CONVERSION_TEST_SOURCE

(

...