We currently have a database that is searched using predefined keywords that correspond to specific columns. The search is very fast and accurate but is not very flexible. I have been tasked...
Hi can anyone check my SQL to see if its ok.
I had trouble gettin it to work with MS Query, and I have been forced to remove my parameters (apparently you can't have variable parameters wit...
I have a todate and fromdate entered on a web page which i am passing to a sql query to search for records between certain dates.
When i complete the query i get the error: error converting d...
I inserted the fields from one table into another, unfortunately we missed copying 2 fields. Now I need to update table # 2 with the values that are missing from table # 1.
This is the tabl...
Hello,
I've a Stored Procedure see below. But when I add a nieuw record with a empty textbox by Address I received a value Null in the table, but I want to have a empty/blank field.
How ...
Hi Experts.
Im having problems updating a column in one table where another column in the table is equal to a column in the table which I want to use to update the table.
For example: I ...
I would like to concatenate columns from a table into a csv string. The table may have a unkown number of columns (max of 158).
The table looks like this: id, col_1, col_2, col_3, col_4,....
Hi all, how can I do this so that I get the totals for EACH individual customer, everything works fine in this query, BUT it gives me the total for ALL customers. What can I do to make it so ...
I have a table containing the following:
ID Value
ABC1 111
ABC1 222
ABC1 333
ABC2 111
ABC2 222
ABC2 ...
Hi,
I need to be able to retrieve invoices from the invoice table for the past month for customers who haven't received an invoice in 6 months. I have been trying to use sysdate with add_mo...
I have this query that sorts through an Access database and pulls out a list of all the calls that took place on a specific extension. The query works for pulling all the calls, then when it d...
I want to create the same table from another table in my database. How do I write a sql statement to do a duplication of the table structure???
I am attempting to fix some corruption in a database whereby a column in the ASSET table has not been set correctly but the required value is in another table.
I have created the following ...
I would like to declare and call a function in PL/SQL from a main procedure in a package. Let's say my main procedure is called view_art. I wish to call a function get_name from view_art which...
I am running a stored procedure. Following the query I have listed below, I would like to get the maximum of the v_a and v_b and set it to v_c. For example, if the query set v_a=5 and v_b=10...
i have a table with a list of people. I want to count each person in the n the table.
for example
Field1
Patsy
Patsy
Sue
Sue
Sue
Jack
Jack
I want it to number like this
...
Greetings Experts,
I need some help with a query I am writing. I am trying to calculate an average on two fields but show the results by a group, not each record. Here is an example
Ta...
I have a column BillingName in the table C02.Customer. I need the name split into the fields LastName and FirstName. The data isn't consistent however. What would be the best way?
Data:
...
I have an access table and I want to run the following sql commnad:
select count (distinct field) from table
In ms sql 2005 it works fine but not with access sql
Trying to capture a Null value in SQL WHERE statement. Currently I am receiving no data back from this (even though there are Null fields). Current code is as follows:
SQLQuery = "Select ...
I had a drive crash on my SQL server so I got a new server and installed SQL 2000 but I would like to restore the MSDB from backup to the new server so I don't lose all the procedures. Does an...
Hi,
I want to know
a) different ways to encryprt and decrypt data in PL/SQL.
b) My actual requirement is to encrypt a flat file using pl/sql and then decrypt it back when required.Plea...
I have the following SQL statement and I get the error Data type mismatch in criteria expression.
InterventionTimeID is an autonumber
InterventionTimeHours is a number
Please help.
Thanks...
My query used to use case statement but the datafields changed. (I included sample of old CASE)
I now need to use terr_id field - which returns data such as 1-1-1-4-1-1-29, 1-1-3-17-1-4-24
A...
We have an invoice table (SOP10100). Every weekday I'm running an update statement to modify the DOCDATE and INVODATE fields to a previous date (If Monday, I make it Friday's date, otherwise ...
