Hi
Can anyone tell me what is wrong with this query? I thought it was so simple, but it tells me "Operation must use an updateable query".
UPDATE [Data Extract]
SET [Data Extract].[Unit ...
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 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...
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 ...
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...
I have a table of name login
I need to create a select query which compare the dateChanged Column with the current date on the server and return true if the value of dateChanged is more then ...
Does anyone know how I can create a T-SQL script that takes a a file, say C:\folder1\me.txt, and move it to C:\folder2\? I know I can do this with a batch script, but I need to do it using T-SQL.
I am trying to concatenate the rows of one column into one string but for some reason my query never finishes executing. It looks like it's going in an infinite loop.
Here's how the source ...
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 attached SQL query which taking hours to run. It badly needs optimising but I'm no SQL expert!
Any help greatly appreciated!
I think it's the like bit which is slowing the query...
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'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...
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...
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...
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?
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 sql string here that is not running correctly. I am trying to concatenate 2 fields, referrer and the count of the cases, into one field to display in a drop down list. Something is wr...
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...
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:...
how to use left outer join when there are multiple tables in from and where clause?
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 >>...
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...
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...
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 am currently using this to get the start of the day,
CAST(FLOOR(CAST(GETDATE() AS FLOAT))AS DATETIME)
what would i use to get the start of the month, also could you explain what the expr...
