We have a jobs table. On insert of any data, we want the data copied to the similar table in a different database in the same server. what is the syntax for writing insert trigger?
I have a record set returned which returns the following sample dataset
"Select productid, class from product_class"
PRODUCT ID CLASS
001 A
001 ...
I wrote the code attached onload of form to handle NULL values.
While this works with a normall datagrid, it does not work for ComponentOne c1truedbgrid.
the default balues do get saved, how...
Hi there
I'm trying to update a field in one table from another table in a different db, this is what i tried and it comes back saying 500+ ropws successfull but nothign has changed. Can so...
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...
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 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 am attempting to create a query which will find the first missing number in a sequence of number in a database. For example, I have a field that may have the numbers 1-10, missing 11, have 1...
I need to update a table in SQL 2000. I have a table named table1 and a field named staff. I would like use a query to change all the values under staff that has a value of 'bc' to 'vs'. Seems...
Hi,
I am writing a SQL procdure which need to only add minutes value in a DateTime data. For example
Day1 = '8/5/2007 12:00pm'
I want to add 90 minutes on it to get Day2 = '8/5/2007 13:...
Hey all,
MS Access 2003.
the following SQL statement runs and works ok except for Field3:
INSERT INTO Table3 ( Field1,Field2,Field3)
SELECT Field1, Field2, Field3
FROM Table2;
it i...
I have a table that looks like this:
CarID CarName CarColor
------- ----------- -----------
car10 Infany Blue
car11 ja...
I have the following SQL statement:
SELECT Instance, Phase, Start_Date,
End_Date, Resource
FROM vw_Info
ORDER BY Instance
It produces results as follo...
Hi guys,
I've got an Access Database which stores a history of Vehicle MOT's (annual road legal check done to cars in the UK). The global ID for each vehicle is VehicleUID, now I have creat...
Hi experts,
I want to interrogate an sql table for null values. How do I do that ?
I tried the following
Select * from prrclmas (table) where recalldate (Date field) =' ';
and this does ...
Is it allowed to sum across the same columns twice in the same query? I get the correct result for the first sum but the second gives me 17962. That number makes no sense at all. While I was t...
Is there an easy way to sum the columns in a cross-tab query?
Hello!
I have two tables as shown below.
As you can see for each version the column_id may have a different column name. So 1 = Supplies for version 1 and 1 = Other for version 2.
In the da...
Hello
I hope someone can help me with this query. unfortunately this one's beyond my sql reporting skills!
Please see the attachment for an example of the table I want to report from. ...
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...
Trying to run a Stored Procedure once an hour, send the output and a datestamp to a file, but I'm doing something wrong. Using a command (Windows 2k3): "isql -Uuser -Ppswd -Ssvrv -iMyScript >>...
Hello I am tring to add a user to all of my DB's named HTML_ howerver I am getting a syntax error Msg 102, Level 15, State 1, Line 30
Incorrect syntax near ''-
Here is the Query
Decla...
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...
I am running a query that is returning some summary data from a table in Access. I have built the query with the intentions of it driving an Access report, but I want to limit the rows returne...
I'm thinking of a solution for following query without explicit inner join or subquery:
Table FXR:
FX_Code|FX_Rate|FX_Date
'USD',1.15,'2008-01-01'
'USD',1.2,'2008-02-01'
'EUR',1.1,'2008...
