Viewing 7 posts - 181 through 188 (of 188 total)
Lynn Pettis (10/23/2008)
name <> 'name1' and age <> 25
That is equvilent to this:
not (name = 'name1' or age =...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 23, 2008 at 9:41 am
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 23, 2008 at 9:37 am
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
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 23, 2008 at 8:32 am
Great QotD! One of the rare ones that isn't easy to cheat on.
Thumbs up!
Ronald
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 13, 2008 at 4:47 am
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,...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 3, 2008 at 2:18 am
Such stored procedures are great for confusing anyone who needs to debug your code 🙂
Ronald
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
August 25, 2008 at 4:02 am
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...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
August 21, 2008 at 2:07 am
Viewing 7 posts - 181 through 188 (of 188 total)