Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Date queries in SQL/Delphi
Name: d.officer Date: April 15, 2003 at 14:10:54 Pacific OS: Windows 98 CPU/Ram: Athlon 1400 / 128
Comment:
Being fairly new to Delphi and SQL, I am having a problem in querying dates within a database - using the form WHERE table.datefield > 'requireddate' does not seem to return the right results. I am using Delphi 5, Paradox 7 tables and my date format is dd/mm/yyyy. If it is a problem with the date format, please can you tell me how to change it.
Summary: heh, i dont think its possible to make a query returning different number of colums. not sure if this going to work on sql server, but in SQL Languange, for combinining records, you can use group by c...
Summary: I'm getting duplicate rows when I joined three tables in SQL 2000. Table 1: employee fields: last name,first name,ssn,rec_num Table 2: hepatits date1,date2,date3,employee references rec_num in employe...
Summary: Hi, I am new in SQL. I need someone's help. I have table which contains: userID, group 123 1 234 2 345 1 456 3 ... I want to write a query which can base on group write into differ...
0 
