Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

BETWEEN Expand / Collapse
Author
Message
Posted Saturday, March 3, 2012 3:07 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 4:05 PM
Points: 33,165, Visits: 15,299
Comments posted to this topic are about the item BETWEEN






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1261195
Posted Saturday, March 3, 2012 3:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 5,586, Visits: 24,936
Nice question - gets one back to the basics, which unfortunately we tend to forget.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1261196
Posted Sunday, March 4, 2012 11:03 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 11, 2014 10:25 PM
Points: 1,287, Visits: 1,116
Nice basic question. Good to have point added.

--- babu
Post #1261398
Posted Monday, March 5, 2012 12:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 13,563, Visits: 10,440
Aaah, an easy Monday morning question. Thanks Steve.



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 #1261421
Posted Monday, March 5, 2012 12:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:47 AM
Points: 2,496, Visits: 2,377
I couldn't believe, it's too easy!
Post #1261428
Posted Monday, March 5, 2012 1:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:40 AM
Points: 1,629, Visits: 5,568
Good thing I actually looked up the T-SQL definition of this before answering, because I wasn't sure if it should include the endpoints or not...the actual English word "between" is a little inconsistent on this point!
Post #1261435
Posted Monday, March 5, 2012 1:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 6:23 AM
Points: 1,412, Visits: 1,821
Nice and easy question to get the week started. Thank-you, Steve!

Everyone: Have a great week ahead!


Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1261443
Posted Monday, March 5, 2012 1: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: Thursday, August 14, 2014 7:02 AM
Points: 892, Visits: 1,240
Nice question and good to start the week on a +1. Almost appeared to be too easy which made me stop and think before choosing my answer. Between is one of those words that can be interpreted different ways. Stopping and thinking before jumping in is perhaps a good thing to do - epecially on a monday morning.
Post #1261447
Posted Monday, March 5, 2012 2:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Nice QOTD to start the week.
Thanks Steve.
Post #1261455
Posted Monday, March 5, 2012 2:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 12:40 AM
Points: 1,315, Visits: 476
I thought it would be too easy, without any trick, and i answered 5. I hoped, DATE fields have a time offset 12:00, but they haven't.
Post #1261458
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse