Hi All,
I have a situation where I want to mask an employeeID column in a database (DB2). I want the data stored on the database to remain 'in-the-clear', but I want to be able to create ...
Basically what the title says. I need to write a sql statement that essentially looks like this:
update table set column1 = column1 & ', newvalue' where id = passedvariable;
Thanks!
My form is in a loop, but if a checkbox is not checked that is in sequence, meaning you miss a row from being checked I get the error "Type Mismatch"
I have a tricky record selection question. I'm trying to select from our database all records from the Installer table (which holds labor cost data) that reference Invoice Numbers that refere...
How can i prevent the attached statement from returning the same item multiple times?
I want to know how to construct a SQL statement to present the data in a different perspective than "by entry." Basically, I want to turn a row into a column. This is hard to explain, but ea...
Hi I have this code here but something is wrong:
select a.Title
from t_ABC a
where a.version = Max(a.version);
The table contains multiple entries with the same title, having a diff...
I need to modify an existing query to contain a difficult calculation.
tblAllTasksEachActivation shows the times of each activation of a given task. If the active box is checked in tblAllT...
Hello, Im having trouble writing a sql query. I need to select l.LinkID, l.NavigateURL, l.ImageFile, l.Status and then also get a sum of rating field and a count of LinkID field where LinkID...
I have created a SQL statement that retrieves the required data from the database, Is there a way I can concatenate two records into one record. In other words
From the resulting table:
ID...
My sql is:
SELECT IMCVEHICLES.VID, MODEL_CODE, MODEL_DESCRIPTION, SUBMODEL_DESCRIPTION,
ENGINE_TYPE, LITER, FUEL, FUEL_DELIVERY, ASPIRATION
FROM IMCVEHICLES, IMCVIN
WHERE IMCVIN.VIN='JA...
I have a tricky JOIN problem.
My stored procedure takes a xml in-parameter in which all rows together forms an unique identity. The number of rows is dynamic, e.g., there could be one row, tw...
hello experts,
i am getting the following error when i run the attached sql statement ...
[microsoft][obdc sql server driver][sql server] The converstion ofa char data type to a datetime...
I know how to create a union query between two tables.
Is there a way to create a union between 2 queries? (Instead of tables)
I want to create a query that gets the results from one query...
I want to delete any records from a table (tblAllData) before I append new records from qryNewData. I don't know how to do this. Subqueries are a mystery.
Here is my SQL
DELETE tblAllDat...
Hi There,
Below is the data of the table "Shipments". The two fields in this table are "Product" and "Shipment-Arrival-Date". I want the result as displayed in coloumn "Diff". The numbers ...
Is there a way to have a select statement that shows a description by date.
If the date is today date or pass date description will show up if the date is a future date then the descriptio...
Greetings Experts,
I am having an issue calculating the average of 2 fields. Here is an example
Table1
Disrepancies PatientCount
50 9
I need t...
I have the following table (MSC_incoming_final) on Oracle 10g
SN type callingnumber callednumber call_date call_time dur_sec inc_trunk code managment
---- ----- -----...
I have some code which collects data from a query and fields on a form and updates it to a table, when run it gives me the error
...did not append all of the records...x field(s) due to type ...
I would like to change field designation to allow Null or 0 to feilds in the Leads and Accounts tables in a MySQL DB. I am currently using Database Workbench, but I have MyPHP admin as well as...
I am currently doing:
SELECT * FROM assets
WHERE ParentId LIKE '%184%'
which gives me the results
Name Comment ParentId
test1 444 184-62-60
test4 345345 184-...
Hi Experts,
I have the below SP, when I execute the insert part from asp.net , I get this error message. The error started after I combined the scope identity with the application number to...
I have 3 tables:
---
Table: onlineimages
Fields: image_guid, image_pubdate, import_sort, image_description, image_user
---
Table: ImageTags
Fields: image_guid, tag_id, imagetags_id
--...
For each email address in my table I need to query the latest 3 records and then check that each record has the same value in a certain field.
For example this will select the top 3 by date...
