From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05. It also looks like it doesn't matter when they will be checking out. Try the following query:Select <ColumnList> From <Table> Where ArrDate Between '08/01/05' and '08/10/05'
2005-01-04
Why do you want to do this? What are the requirements? Here is a fun "Select" SELECT DatePart(s, Getdate()), DatePart(s, Getdate()) + 1, GetDate(), DateAdd(s, 1, GetDate())
2004-12-27
1 reads
Ever thought of encrypting that sensitive data? That won't stop someone with sa privileges from watching the data, but he will not understand what he sees.
2004-12-16
I have INSERT tbl2 SELECT id,fname,lname from tbl1 WHERE ref# = '123' This works fine but what if I just wanted to insert fname and leave lname out (which would insert NULLS in that column).
2004-12-16
2004-12-07
great advice above. One more I'd add - SQL Litespeed. Works great and has reduced our largest backup substantially in size and time. Went from 60G native to 9GB with Litespeed. Times went down from 90 minutes to around 40 minutes. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-13
1 reads
Good question! Well IMHO a good developer is a good visualizer and tansformer i.e. visualizes the problem its pros and cons its limitation and then transform it to any language he knows or always can learn a new language. regards.
2003-06-13
1 reads
quote: When it's art, courage is important. Not knowing how to do something but still willing to look silly, asking basic questions and making mistakes. And trying things nobody else has, or has been willing to try. Seriously, this is probably the best discription I have heard so far. NPeeters: Yes, beer back again. 🙂 […]
2003-06-11
If you want to post the VB code, I can take a look. We have successfully used COM+/MTS components here for a while and have gone through the gammet of weird MTS errors and hangups. Just be sure that you are properly using SetComplete and SetAbort on the ObjectContext and that your error handling is […]
2003-06-11
.\ is the local machine, so it is using an account on that machine as opposed to the domain. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-11
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers