Help with a Search

mcad

    Sponsored Links

    Next

  • 1. Newbie: Help
    I want to write .NET certification exam. Can anyone send me the details for the same with weblinks. I am wondering whether .net certification and MCAD is same or not. Please explain. Some guys say to write certification from brainbench. what is this? How it is different from MS? shiva
  • 2. Looking for Help / Partner To Run Popular MCSE Forum Site
    I currently own a popular MCSE website which I need help running. I am willing to pay someone to help out, I currently do not have enough time to run a hugely successful site like this by myself, with 1000's of members. I am looking for someone with the following. -Needs to have a strong MCSE background -Ability to Add content/articles to the site -Moderating the site -Keeping members happy -Advertising the site, possibly ?? -Needs to have lots of spare time to look after the general running of site -Think this is about it? If intrested please e-mail me at XXXX@XXXXX.COM

Help with a Search

Postby Kissi » Mon, 05 Jan 2004 16:53:36 GMT

Hi,

Could anyone please help me with any method to search a database. I am
trying to search for range of dates. Example: I want to find if
1/02/2004-1/15/2004 exit in a database. The table has two fields;
StartDate and EndDate.
Thanks



Re: Help with a Search

Postby Hermit Dave » Mon, 05 Jan 2004 20:21:45 GMT

first you are in the wrong newsgroup.... should probably be in
sqlserver.programming

i am writing you a simple select.... do something like that

select * from Activity where
(StartDate Between '1 January 2004' AND '15 January 2004')
OR
(EndDate Between '1 January 2004' AND '15 January 2004')

-- 
Regards,

HD









Return to mcad

 

Who is online

Users browsing this forum: No registered users and 34 guest