Hi - I have been given a file which I need to create a new table out of in Oracle, unfortunately, the source of the data doesn't have the ID of the system we are trying to get the data in. In...
Hello!
About my environment:
I have a hosted web database that I don't have access to other than with classic ASP and an ODBC connection that thankfully gives me both read and write access...
I create a column using CREATE TABLE ... ColumnName INTEGER IDENTITY(1,1) NOTNULL so that it is intialized to sequential numbers when I insert records from a select query. I want to alter the ...
I would to use the following example as a sql statement:
SELECT sum(fieldNameX) FROM tablelName WHERE x='1' AND y = '2' ORDER BY fieldNameY LIMIT start, rows
My actual SQL statement is t...
Alright,
I am getting an Invalid argument error anytime I try to Run,save, close, or anything to a query or table.
Any Ideas.
Compact and Repair doesn't do anything.
I have a table:
data_table
subject year totaltested
I want to change this query:
SELECT
subject,
year
FORMAT(SUM(totaltested), 2) AS total,
FROM data_table
...
I have a form which uses checkboxes to create a field in the database which contains a list of people assosciated with a project. The problem is I need to select from the database where a user...
Good afternoon,
I have a databases and I'm trying to get a portion of one table to a table in another database and when I run the following query it does transfer over the information and i...
Hey guys,
Im trying to populate a new column in a database query based on the content of an exisitng column.
Basically if the existing column entry has a certain format, i.e. if its an IP ad...
Hello All,
I am trying to import these fields into an Access DB.
The trick lies in the fact that I am attempting to insert one instance of 'FullName' and 'Email' Fields, while t...
I have a table called Product with a field called ProductCode and one called DiscountType, both varchar.
I have another table called SubProduct which has fields ProductCode and SubProductC...
Looking for some SQL query assistance.
2 questions:
1. Is there a way to add a dummy column to a select statement. I'm querying my db and then sending to a Recordset in VBA and then co...
I have a need to "Transpose" (Excel Term with which I am familiar) the results of a summing query.
The query sums multiple columns, so it is essentially one row of numbers and a row of head...
I have the following statements in the Query analyser (SQL server 2000).... can not be simpler
SET IDENTITY_insert attendancetype on
insert into attendancetype select * from members..atten...
I have a database (Access 2000) of Bird sightings, and am trying to create a Query that can produce 'year lists', by showing all the individual species of birds seen in a specific year.
As I ...
I need to populate a table based on a user filter. In Access i just try to insert all the records the filter returns and allow Access to skip the duplicates. That worls great.
However in...
I have a query with an "is not null" criteria but some of the results have null values for that field.
I have exported the results as a text file and evaluated the results and those fields ...
Help !
I am using sqlplus 8.0.6.0.0 and I have a table with:
my_user,
start_date,
end date
in the table I have my_user ID eg AI6097 and a start dates eg.
AI6097 01-MAY-07
AI6097 ...
Hi
I want to use an IF statement to check if a SELECT statement returns values. If the SELECT returns values I want to do one thing, and if it does not return any values I want to do anothe...
I need to get just output in my query - I have tried the following but it will still output SQL>exit in the on.txt file:
SQL> spool on.txt
SQL> select sysdate from dual;
SYSDATE
------...
Hello
This could be a simple task for some of you but I am finding it difficult to write a query for following task.
I am building a query using one variable and then I want to assign th...
Hello,
I am trying to implement the following Trigger into a table in SQL Server 2005
http://jamesewelch.wordpress.com/2007/09/04/tracking-database-record-changes-at-the-field-level/
I...
How do i speed up SELECT JOIN query for 2 large tables? (teststock and prdbesarch)
I've been using this code for a while now and it seems to be working fine.
One table is teststock and l...
Microsoft Access Query Question:
In my select query results, I have unique data outputs in rows found in column B that are related to another attribute (Markets) in column A.
Example:
...
I am attempting to create a trigger (using some great information I received from you experts earlier in the day). However, apparently I have some holes in my logic. It looks like the INSERT...
