Good back to basics question... I'm glad I had my morning coffee first or I would have missed the 1/True bit. 🙂

You know you're starting to get paranoid when you're always looking for the catch.

Glad that I couldn't find one and got it correct 🙂

That's what GROUP BY and MAX are for 🙂

DECLARE @persons TABLE(

personid INT,

version INT)

INSERT @persons

VALUES(1,1),(1,2),(1,3),(2,1),(2,2),(3,1),(4,1),(4,2)

SELECT

personid,

maxversion = MAX(version)

FROM...

/agree I was starting to get paranoid.... finally gave up and went with my...

MyDoggieJessie (8/7/2012)

---

All jokes aside 😉 when removing the index hint the optimizer automatically turns it into an index scan...so that's why I was trying to force it to use the...

Ok, next time I will remind myself to read the dates on messages in here... at least one response to something that was already handled last month. Oops 🙂

Luis Cazares (8/7/2012)

---

But it does matter if we're talking about number of rows returned.

With select * you can get either 1 or 0 (in this particular case).

With select COUNT(*) you'll...

Lynn Pettis (8/1/2012)

---

morepainot (8/1/2012)

---

Ok, I took care of those errors. Now the only errors I am getting are

"Msg 2714, Level 16, State 3, Procedure usp_PreStageValidation, Line 185

There is already...

Jeff Moden (7/26/2012)

---

Sean Lange (7/26/2012)

---

@jeff - You need start the official anti-RBAR alliance and offer membership to those who have proven to be members. We could have a secret handshake...

manub22 (7/26/2012)

---

Lot of problems can be easily done by SET based approach rather than using CURSORS. People not expert in writing SQL queries and/or not aware of new features end...

Luis Cazares (8/7/2012)

---

SQLRNNR (8/7/2012)

---

As far as I remember, the "Select count(*)" was changed by Steve after the discussion on the previous question and originally had a "Select *".

However, I don't...

I'm like Jeff.

I use CTE's to move subqueries to the top so I can treat them as the proper named derived tables that they are.

I also use them when I...

Must agree with Sean and Dwain.

Either pass in separated values and split the strings to a temporary table/table variable and join to that, or if you feel comfortable pass in...

Could be a test question.

A decade ago when I taught Database Theory, my tests were take home week long projects.

25 T/F

25 Multiple Choice

25 Fill in the blank

25 point Essay question.

During...

declare @ProductLine table

(ProductlineID int)

declare @Products table

(ProductLineID int,

ProductID int,

Status int)

insert into @ProductLine values (1)

Insert into @ProductLine values (2)

Insert into @ProductLine values (3)

Insert into @ProductLine values...