Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » SOME
Add to briefcase
35 posts, Page 1 of 4
1234»»»

SOME Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Posted Tuesday, March 20, 2012 10:31 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726
Comments posted to this topic are about the item SOME






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1269998
Kameswari Aravindh
Posted Tuesday, March 20, 2012 11:44 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 3:46 AM
Points: 2,223, Visits: 177
Nice and Easy Question. Thanks
Post #1270006
Koen Verbeeck
Posted Tuesday, March 20, 2012 11:57 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 9:06 AM
Points: 9,367, Visits: 6,465
Nice question, thanks.
Never use ANY or SOME though



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1270010
Carlo Romagnano
Posted Wednesday, March 21, 2012 2:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:04 AM
Points: 1,968, Visits: 1,819
Is there difference between SOME and ANY?
Can someone explain?
Post #1270043
vk-kirov
Posted Wednesday, March 21, 2012 2:26 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:59 AM
Points: 3,188, Visits: 4,141
Carlo Romagnano (3/21/2012)
Is there difference between SOME and ANY?
Can someone explain?

There is no difference. http://msdn.microsoft.com/en-us/library/ms175064.aspx:
SOME and ANY are equivalent.
Post #1270046
IgorMi
Posted Wednesday, March 21, 2012 2:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:57 PM
Points: 1,875, Visits: 1,439
Hi all,
Interesting questions...also the following query:

SELECT id
FROM dbo.SalesDates s
WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the example dates, it produces the same results as with ANY and SOME.
(http://msdn.microsoft.com/en-us/library/ms177682.aspx)
Post #1270049
IgorMi
Posted Wednesday, March 21, 2012 2:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:57 PM
Points: 1,875, Visits: 1,439
Hi all,
Interesting questions...also the following query:

SELECT id
FROM dbo.SalesDates s
WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the example dates, it produces the same results as with ANY and SOME.
(http://msdn.microsoft.com/en-us/library/ms177682.aspx)
Post #1270050
IgorMi
Posted Wednesday, March 21, 2012 2:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:57 PM
Points: 1,875, Visits: 1,439
Hi all,
Interesting questions...also the following query:

SELECT id
FROM dbo.SalesDates s
WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the example dates, it produces the same results as with ANY and SOME.
(http://msdn.microsoft.com/en-us/library/ms177682.aspx)
Post #1270051
skanker
Posted Wednesday, March 21, 2012 2:55 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 8:14 AM
Points: 692, Visits: 1,021
Good question. I have never used ANY or SOME in queries so have learned something once again.
Post #1270054
palotaiarpad
Posted Wednesday, March 21, 2012 3:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:54 AM
Points: 844, Visits: 318
The good thing in ANY or SOME is that you can make all kind of comparison not only equality or inequality.
Post #1270076
« Prev Topic | Next Topic »

Add to briefcase
35 posts, Page 1 of 4
1234»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.