|
|
Actually he shouldn't use that type of date format since it can fail.
Better is to use the SQL standard: yyyyMMdd
select productname,sum(issueqty) QTY from issuance
where issuedate >= '20100501' and issuedate <= '20100531'
and productid in ('777' ,'778')
group by productname
order by productname
|
|
|
|
|
Tom Deketelaere wrote: that type of date format since it can fail.
Can you elaborate? What would allow or cause it to fail?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
In the UK, the date '5/31/2010' would fail if you localize the database because we format dates as dd/mm/yyyy. Using yyyymmdd format or explicitly using CONVERT is much safer.
|
|
|
|
|
I guess that falls under the DAH!! category. Obviously if you are using dates they must be in the correct format  Using universal time will ensure these issues do not arise.
'20100501' is just as likely to be mistyped and cause issues.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
At a guess, regional settings:
5/1/2010 can be interpreted as 01-May-2010 or 05-Jan-2010
The second date, 5/31/2010, is presumed to mean '31-May-2010' and provides context for the first date.
I encounter this issue on a regular basis; especially when 'constructing' datetime stamps on the fly.
For example, our mill production day starts at 7:00 AM.
For for month to date information for a given date, I have to build the date as:
'01-' (month of given date) '-' (year of given date).
Hope that helps.
Tim
|
|
|
|
|
The implication I read was the OP said it would fail because of SQL server issue. Of course you must use the proper date format. That's user error not a SQL Server issue
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
No I mend for the exact reason Tim talks about. Sorry if that wasn't entirely clear 
I encounter this a lot.
Very often ours clients pc will be set to the correct regional settings (Belgium settings) but there server (installed by hardware guys) is almost always set to the English settings, so without using the SQL standard format things can go very wrong and act very weird.
|
|
|
|
|
hi,
i work on odbc datasource with windows server 2008 r2
i go to c:\windows\sywow64\odbcad32.exe and create a dsn
when connect to this dsn an error ocuured,
the error is:
[Microsoft][ODBC Driver Manager] The specified DSN contains an
architecture mismatch between the Driver and the Application
how i can solve this problem
thanks alot
|
|
|
|
|
Are you trying to use this DSN in a 32-bit application perhaps?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hello.
Im having few textboxs,image button and Button in a page.
default button is set to button control and focus is on one of the textboxs but when i press enter after page loads the control shifts to image button. Why does this happen?
|
|
|
|
|
Sorry i posted in wrong forum..
|
|
|
|
|
hello
I am working on one win app with sql database visual basic i have created 4 tables singlecustomer, jointcustomer, address and plotdetais. I have created relationship with all 4 tables singlecustomer with address and plotdetails second jointcustomer with address and plotdetails and then I have also created database diagram and it show all the relationships now when i drag and drop sql adapter to configure it database relationship dosent look right in query builder it's not showing correct relationship with all tables. in query builder when i add tables first time it's different relationship and then i canceled it and add tables second time with different order so it shows different relationship
waiting for your kind help
thanks
|
|
|
|
|
Sorry I don't understand what your problem is, you can change the join in query builder if they don't suit your query.
Seems you have almost no knowledge of databases and are relying heavily on the built in tools to do your work for you. I suggest you get a basic book on database design and start learning. Using a forum for your basic learning is NOT a good idea, get a book or do a course!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Let me try to rephrase this for you using sentence structure:
"I am working with a windows app with sql database and vb. I have created 4 tables:
singlecustomer
jointcustomer
address
plotdetails
I have created relationships with all 4 tables:
singlecustomer related to plotdetails and address
jointcustomer related to plotdetails and address
I have created the database diagram and it shows all of the relationships.
When I drag and drop a sql adapter to configure it, the database relationships don't look right in the query builder.
In query builder when I add tables the first time, it shows a relationship. When I cancel it and add tables a second time in a different order, it shows a different relationship"
Now, that's what your question looks like with proper sentence structure...however, it still doesn't make a lot of sense.
|
|
|
|
|
|
This is an advert for his database. Guess which one?
|
|
|
|
|
My database. Thanks a lot for this compliment.
That is one very impresive benchmark which is OpenSource and is quite suited to get an overview about the performance of the different DBMS. Wich DBMS will you using is only your choose.
Between I'm PHP programmer and until this moment i'm using MySQL.
Best Regards, Good Luck.
|
|
|
|
|
Well at least he chose an appropriate userid. 
It's time for a new signature.
|
|
|
|
|
I think he needs to invert the 'p' to a 'b'. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
Hi,
I'm trying to create an album gallery, which works this way:
First, i have the album photos with description on each album under the photo, with a pager. ( that was done)
Second, when you click on a certain album, you see all photos related to this album only.
I am using ACCESS DB. i just cant figure it out how to connect those data correctly, and how clicking an album will take me to the photos related only to it.
I would appreciate any help or samples for such a thing.
Thanks,
Basil
|
|
|
|
|
That would depend on your schema.
|
|
|
|
|
Hi,
I have a Address field.I want to make a query that returns all records that their addresses contain all words of a address in any order.
Suppose 'John street , No 2' is the address, I want to return all addresses that contains 'John' , 'street', 'No' and '2' in any order.
How can I make this query?
Original string : My name is Mehrdad
Best wishes
|
|
|
|
|
Use and with like
SELECT *
FROM Somehwere
WHERE address1 LIKE '%John%'
AND address1 LIKE '%Street%'
AND address1 LIKE '%No%'
However this is not going to help where you have St instead of Street ,Rd instead of Road and many many more issues that arise from cleaning address data.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You can use SOUNDEX[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
