Hi,
I have a form with a browse feature and a combobox.
I need users to first select the file they want to import. Second, select a group that is defined in the SQL DB.
Both of these MUST b...
I have a string variable NAME: " 'name1','name2','name3','name4' "
If I do
select translate('NAME','!@#$%^',' ') from dual
to replace all of the characters to spaces it doesn't work...
Honestly, this is a school project I can't figure out a small part. I'm using Oracle 10g Personal Edition and always use SQLPLUS. There are two tables, PROCEDURES and TRANSACTIONS.
The ...
Here's some values I need to insert into this into the configuration table, but I don't want to overwrite something it if has the same 'configuration_id'
So basically if I'm inserting it in...
I have a stored procedure that exists in 2 parts:
1st part is a simple INSERT statement
2nd part is looping through a comma delimited string with invoiceID's
In this loop another stored p...
I am trying to build a case for possible file_types to display them in these groups...
1. One that contains all 3 file_types (0 and 1 and 2)
2. One that MUST contain at least BOTH of these ...
"A Cartesian join is when you join every row of one table to every row of another table. "
It make sense. Lets look at an inner join:
select emp.employeeID, order.orderID
from employees...
Objective: SQL Statement that concatenates two fields into one.
The statement should return a 16 character field (comprised of two fields and spaces)
Field one is entityid - Note this...
I am trying to get an SQL query to calculate the year-to-date on a mm/dd/yyyy date field (it gives only the first day of every month -- 7/1/2009, 8/1/2009, etc)
This would be the months sta...
I have a function which returns boolean value, I need to use this function in a where clause of a query. If the function returns true for a particular row, then that row should be queried.
So...
how can I set a default value in a select clause to avoid getting a NULL value?
In this simple query the PartialPayment value can be NULL and I would like to return a 0 (zero) by default fo...
I need a function or stored procedure for MS SQL 2008 which splits the following value that is entered through a single field:
The function should take the value: '-122.0846330,37.4218230,0'
...
I have been using an SQL select statement similiar to the one below to compare a SQL table datetime column field between two dates a user enters on a form.
SELECT * FROM mytable WHERE (CONV...
I want to return a maximum of 250 records from a query. However, I also want the message that accompanies the returned records to read, "Your search resulted in (put count here) records. Only...
hi all, i keep getting runtime error 9 subscript out of range. i think it may be on the strSQL line at splitText3(1) which is part of an array..
any ideas would be greatly appreciated (as a...
Experts,
Let's say I have two date-time fields and I want to subtract the start time from the end time. If the start time is 10 am and the end time is 10:30 am, I want 30 as my result in i...
I am new to the Data Grid [and asp in general]. My need is this: I would like to be able to add and update data inside the Data Grid as indicated in both the screen shot and code below.
I t...
Hi All,
I have a SQL Query below for reservation system to check for availability. Let say the return result is
Date | Status
------------------------------
01-01-2009 |...
Don't know why I get many of these error when I run my code. It happens at the line of code:
SET @Name = SUBSTRING(@Name,CHARINDEX(',',@Name) + 2, LEN(@Name) - CHARINDEX(',',@Name) -2)
Can ...
Is there a way to make this only drop the 'product_field1' if it exists?
I'm running a loop that creates a sql statement and then executes it. This loop goes through each DB on my server. What I want to do is, instead of executing 50 or so sql statements I'd like i...
How can I get only the numeric values from a string in MySQL?
I need:
'abcde123456' -> '123456'
'(test_123)' -> '123'
'(ThisisText678)' -> '678'
With a regex in perl this would be 1 l...
I wrote a few loops in C# and it works quite fast, but ideally I'd like to keep the datatable bound to the database so that updates to the table can be saved back to the DB. So, I wrote this ...
I have a SQL table with data with one of the column is date_created.I want to get metric for start and end(which will be parameters) date range for business hours and non business hours. Busi...
See full code below.
I'm trying to run an update statement to save all fields. I have three form fields....income, paymentamount,contractamount that are giving me trouble. I'm getting con...
