I am trying to delete a leading space in some of my SQL fields. ANd then I want to delete information after the city word in a column. Here is what infor looks like. Some have a leading spa...
I have data as follows in my table:
a,b,c,d,12/31/07
a,b,c,d,12/25/07
a,b,c,d,12/24/2007
e,f,g,h,12/13/2007
e,f,g,h,12/31/2007
e,f,g,h,12/15/2007
What I want to do is create a table...
The following sample shows a way in which I am returning exactly what I want to see, and is pretty fast to fun, but it just seems like a pain in the butt. I am not just doing totals A, B, C b...
I have a combobox dropdown that i am using as a filter for a GridView. This works perfectly find, except i want to add a "Sellect All" to the filter. I believe this has something to do with ...
I'm wondering if anyone has any suggestions for truncating the decimals in a calculated field in a query. The field seems to ignore the property setting for zero decimal places. As indicated b...
I have two tables as shown in Section A of code details
I need to return a result set that looks like Section B of code details where sh_date=1218420600
The closest I've been able to get...
Hi,
I'm a bit of an SQL novice. What I have and want is:
Property_Agent, Property_Location
James Joyce, Dublin
Harrot Ford, Dublin
Harrot Ford, Dublin
James Joyce, Dublin
James Joyce,...
Hi, How to write a Update SQL syntax which:- Update all the new records to this Currect databse where the records is from Existing Databse. (some records is not exist in current databse)
Not sure what i'm missing here - get a -
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right sy...
Is it possible to do something like this with an SQL statement?
For each UNIQUE value in field 'DCPH' of my SQL table
'____count the # of times a value occurs in a field
...
Hello,
This is my first project and I am using VS Express 2005. I am creating a query from a MS Access database and trying to filter the results by "Transaction date", but the date has a di...
I have two ACCEPT statements to capture two different dates from user input:
SAL_PR_PD_END_DATE and HRLY_PR_PD_END_DATE
For records in table LAB_TRAN that match the SAL_PR_PD_END_DATE
I n...
Can anyone please help me with perl scripts or cmd syntax to do the following please:
1) Output to a text file (> c:\test.txt) free disk space (c$ & d$ disk paritions for example) on Window...
I am working on a sql concatenation issue. From my attached code, all records can accept only one value, accept for the last field, "notetext." Notetext can accept more than one value. If N...
Hello Experts,
I am working on an employee daily activity report.
I have two date spans
startdate_and_time1 and endate_and_time1
AND
startdate_and_time2 and endate_and_time2
These ...
Hi Experts,
I have this SQL querys now I want to use towords Access db as a data source can you please tell me what will be the syntax for this query in MS Access ?
I need to create a stored procedure to check every record in a table sorted by SalesRepNo and SalesID. There is a field called "SalesAmt" that may be positive or negative value and another fi...
hi everyone,
Ive got a bit of a problem. I have a table InventoryItem and another table InventoryItemPieces. I have a routine that selects all InventoryItem but what I want is to select all...
My understanding is that a query with a sorting criteria such as:
[Employee] ASCENDING
[Salary] DESCEDING
or a filtering criteria such as:
[Employee] > "Jones"
[Employee] like "Sm*"
[Sal...
Hi,
I have a table that includes three fileds:
fname, lname and maincontact.
Update fname and lname:
I want to seperate first and Last name within maincontact starting from the right h...
This error is driving me crazy; it's happening in a stored procedure that is defined in the code snippet. The last two strings that are passed to the stored procedure are throwing this error. ...
Hi Guys
I have this php script
$select = "
SELECT
ID,
IPLong
FROM
Tracker
";
$rs = $conn->execute($select);
if(!$rs->EOF){
while(!$rs->EOF){
$select = "
select...
I have an SQL 2000 database table that has a field called DateTaken. I'd like to run one query to give me the starting date and the end date (basically out of all the records what is the fi...
Hi,
Can someone tell me how I would make my query output all records that include the Auth_Prod criteria. It should return about ten rows, but whenever I use design mode and put in criteria i...
I have a database with 3 fields that contain dates. I need to return in one column the date in the column with the earliest date. For example, we have an approved date, denied date, and not ...
