Lynn Pettis (10/23/2008)

---

This gets into basic BOOLEAN LOGIC. Your where clause is this:

That is equvilent to this:

not (name = 'name1' or age =...

What I think you mean that AND behaves like OR, is that most OR conditions logically returns more results than AND (name = 'name1' OR age = 25 gives more...

This would be my solution:

insert into @MyTable

Select SSOUsers_RowID,FamilyType,'ATAS',Param1,Param2,param3,param4

from ssouserservices

where FamilyType='3' AND

SSOUsers_RowID =

(

SELECT MIN(SSOUsers_RowID) MINRowID

FROM ssouserservices

where FamilyType='3'

group by FamilyType, Param1,Param2,param3,param4

)

Hope this helps!

Ronald

Great QotD! One of the rare ones that isn't easy to cheat on.

Thumbs up!

Ronald

I'm also a great fan of SQL data displayed in Excel, and I use it daily. However, I prefer to have the SQL in a stored procedure in the database,...

Such stored procedures are great for confusing anyone who needs to debug your code 🙂

Ronald

We tried to do this (including the removing of the old tempdb files), and it crashed SQL server completely... No idea what went wrong, but we're down to reinstalling completely...