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...
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...
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 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...
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...
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 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...
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...
Hello
My linux server clock does not show the right time.
I tried:
ntpdate 0.pool.ntp.org
But ntpdate is not found.
How can I set the time (or synchronize it) on a red hat ?
rehards
I am looking for ways to improve performance when data is loaded onto the grid view control. I am considering how to implement stored procedures with gridview control. (C# , VS2008, MSSQL 2005...
