I am trying to do a query with an if statement in the where clause, but I am getting a lot of errors I can't resolve.
Here is what I am trying to do:
SELECT * FROM table1 AS t1 INNER JOIN...
Hi,
I am working on MSSQL 2000
When I am executing a below query, I am getting an error
Server: Msg 241, Level 16, State 1, Line 29
Syntax error converting datetime from character ...
I have a MS Access 2003 database that contains several fields as such:
Start_Date Start_time Actual_date Actual_time
20080315 19:00 20080315 18:4...
I have a table that looks like this:
CarID CarName CarColor
------- ----------- -----------
car10 Infany Blue
car11 ja...
Is there an easy way to sum the columns in a cross-tab query?
I have a list of checkbox values that I need to insert into a table. Is there a way to send a list to a stored procedure and then loop over the values to do an insert?
None of these solutions seem to work. Here are my table descriptions and data, with the fields separated by commas:
EMPS TABLE --> EMP_ID (int), EMP_FIRST_NM (nvarchar(50))
1, 'Yvonne'
2...
I have an Oracle SQL query that returns a list of IDs and for each of these IDs I need to loop through them and execute an additional select to get more information about each one of them from...
This is kinda of silly but it's late. I am getting the month name in my query using
DATENAME(month,t.transactiondate)
But I need to use this field the order by clause so I need it to sor...
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...
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 am trying to write a query to insert data into a temporary table if the values in a particular column are null. Can someone help me out with the syntax?
Here is an example to work with: ...
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 ...
The below statement works fine but is giving me a result which is a number with 13 decimal points
rounding off is not working for me . It is giving me round requires 2 or 3 arguments error.
...
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 have the following code as part of one of my sql statements. I'm trying to account for all values in the field that are not equal to Yes, including Null values. For some reason, if the field...
Hi all,
I am wondering if I can use a BETWEEN operator in a SQL statement for the following example?
This is similiar to reserving a hotel room, or something like that:
I want to return...
Hello,
I am trying the following query in SQL 2005 which is generating an error.
UPDATE MailMergeList SET MailMergeList.Address = tbl_DelegatePropertiesSimple.[Field17] FROM MailMergeLis...
I have two database tables. One has a bunch of account numbers, with what was spent for each account during each period of the year. The other table has a range of accounts that need to be sum...
We have a column with a "Text" datatype in a SQL Server 2000 table.
How can I read the whole data from start to finish in a column of "Text" datatype?
It seems that while reading the data ...
I know there is an UPPER and LOWER function in Oracle that can be used to convert text query results to all Upper case or Lower case for symmetry, but is there a function in Microsoft Access (...
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...
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...
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 am looking to write a query to search my entire database for a value in a known field:
Field Name: UserID
Field Value: 1234567
There are many fields called UserID spread throughout ...
