ms-access: date/time data type
i have a table that has a date/time field when i display the report, should i make this column a GENERAL DATE? or something else? i am having problems sorting ...
sql
How do I select distinct rows where a column may have a number of the same values but all their 2nd columns have the same value?
I have a table in the form: test_name | test_result ----------------------- test1 | pass test2 | fail test1 | pass test1 | pass test2 | pass test1 | pass test3 | pass test3 | fail test3 | pass As you can see all test1's pass while test2's and test3's have both passes and fails. ...
ms-access: difference between control source and row source
i have learning reports in access and i don't understand the difference between these two concepts. i understand that the control source is the column? but then what is the row source? ...
How does hibernate use an empty string for an equality restriction?
I have a column that potentially has some bad data and I can't clean it up, so I need to check for either null or empty string. I'm doing a Hibernate Criteria query so I've got the following that returns incorrectly right now: Session session = getSessionFactory().openSession(); Transaction tx = session.beginTransaction(); Criteria myC...
Connecting to Teradata via PHP
We need to access a Teradata database via php application We don't have odbc (unixodbc etc) on the server. How might one go about connecting to a teradata database quickly. Keep in mind - this app needs to be as portable as possible. ...
Use AJAX to watch SQL database for changes.
I have a column in my database that will be updated randomly. Whenever that column is updated I need to refresh content on my page. How can I use AJAX + jQuery to perform an action only on DB changes? ...
SQL query to return all rows that contain duplicate data from one field
I have a table with card numbers and names. Some of those names are the same, meaning they have multiple cards. How can I select all the rows where the name occurs more than once? ...
How to quote and reference SQL Server table and field names
Good day! Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends. While writing SQL for SqlCommand: Is it needed to quote field and table names with []? Is it good to prefix table names with [dbo] I use to use this syntax: SqlCommand co...
XUL: Printing value from SQL query without using value attribute
I want to print the results of an SQL query in XUL with word-wrapping using the description tag. I have the following code: <grid> <columns> <column flex="2" /> <column flex="1" /> </columns> <rows datasources="chrome://glossary/content/db/development.sqlite3" ref="?" querytype="storage" > <templ...
Database Design for One to One relationships
I'm trying to finalize my design of the data model for my project, and am having difficulty figuring out which way to go with it. I have a table of users, and an undetermined number of attributes that apply to that user. The attributes are in almost every case optional, so null values are allowed. Each of these attributes are one to o...
Multiple IN statements for WHERE. Would this return good data?
SELECT ['VISA CK - 021810$'].[ACCT NBR #1], ['VISA CK - 021810$'].[ALT CUST NM #1], ['VISA CK - 021810$'].[LAST USED] FROM ['VISA CK - 021810$'] WHERE ['VISA CK - 021810$'].[ALT CUST NM #1] IN ( SELECT ['VISA CK - 021810$'].[ALT CUST NM #1] FROM ['VISA CK - 021810$'] GROUP BY ['VISA CK - 021810...
How do you keep the order using SELECT WHERE IN()?
Is there a way to keep the order when using SELECT WHERE IN()? For example, using the following query: SELECT id FROM data_table WHERE id IN(56,55,54,1,7); The results will come back using the default order by id. 1,7,54,55,56 When I want to keep the order used in the IN: 56,55,54,1,7 Is there a quick way to do this in mySQL or will...
How can I perform this query between related tables without using UNION?
Suppose I have two separate tables that I watch to query. Both of these tables has a relation with a third table. How can I query both tables with a single, non UNION based query? Here's a theoretical example. I have a User table. That User can have both CDs and books. I want to find all of that user's books and CDs with a single query ...
SQL - How to join on similar (not exact) columns
I have two tables which get updated at almost the exact same time - I need to join on the datetime column. I've tried this: SELECT * FROM A, B WHERE ABS(DATEDIFF(second, A.Date_Time, B.Date_Time)) = ( SELECT MIN(ABS(DATEDIFF(second, A.Date_Time, B2.Date_Time))) FROM B AS B2 ) But it tells me: Multiple columns are specifie...
Best way to Sort-n-Concatenate 5 columns
!!! WARNING !!! Dearest SQL expert, please keep reading before to start to scream. this uber-denormalized table structure is obtained after apply some combinatories-sugar upon a nicely normalized set of data : ). I'm avoiding to renormalize this resultset because I want to keep simple the complete process (also this...
How to build a windows/web application that stores data locally and sync's with remote database?
Hello, I am needing to build an application that stores data locally and then synchronizes with a remote MS SQL database. I am not sure how to go about doing this. Enter data offline on a form and store the data. Synchronize the data with a remote MS SQL database when online. There will be many users who enter data offline, the local...
Cross Join 'n' times a table
It is possible to write a generic function/procedure/select/somethingElse to cross-join a table against himself 'n' times? (yes, 'n' is a given parameter : ) How would you do it? Example Having this table: Value ------- 1 2 3 cross join it 2 times, would return: Value | Value ------------------ 1 1 1 ...
[MS Access 2003 SQL] Switch is causing #error, why and how can I fix it...
I have 3 fields in my table: start, end (dates) and length (number, might be blank). My Aim is to calculate an end date using start and length where end doesn't exist... I have: SELECT Switch((g.length<>0) And IsDate(g.end),DateAdd("m",g.length,g.start)) AS field FROM table g If there is no start, end or length, Access displays blank...
Performance difference if I UNION first, then put WHERE on unioned result set?
In Microsoft SQL, is there any difference in performance between this: SELECT columns FROM table1 WHERE cond UNION SELECT columns FROM table2 WHERE cond and this: SELECT columns FROM ( SELECT columns FROM table1 UNION SELECT columns FROM table2 ) WHERE cond ? ...
mysql multiple where and inner join query combination
I'm a little lost as how to run two mysql queries as one(return one result set to be sorted etc). I understand how to do multiple JOINS but need to combine the below which is more than just a multiple join - it would include a multiple where etc. 1st query sql = "SELECT s.id, s.song_name FROM `songs` as s IN...