lst_chnge_dte is a field on db2 table that is defined as decimal & contains date in format yyyymmdd, for instance 20060405
want to update lst_chnge_dte with current date
was going to use
(s...
I have a database table called tk_Tracking with the following columns and data:
OrderNumber TrackingNum Status
246880 1Z258000AC1 Y
246801 ...
Hello!
About my environment:
I have a hosted web database that I don't have access to other than with classic ASP and an ODBC connection that thankfully gives me both read and write access...
We are trying to find a SQL command that will help us find the table structure of a database. We are talking about 200+ tables on a database. We will be converting from SQL Server to Oracle.
I currently have an access database with a query that I need to tweak. The existing query is:
SELECT ssUsers.custom1 AS Location, Sum(DateDiff("d",[CheckIn],[CheckOut])*[rooms]) AS ActualR...
ok, here's a simple one. i've been out of the loo pfor a while.
How do i insert data into multiple rows? ie:
1 sara
2 sara
needs to go into idnum table
I don't want to have to do t...
Hi,
I have a table sample_1.Following is the structure of the table.
size name
100
sample
The result should be:
size name
100 sample
...
I always want to Round UP no matter what decimal is returned. Example: 369.2 will be 370 just like 369.7 will be 370.
I have two tables with the following columns:
Proc_Property
SPID SPName Parameter
1 SP1 @Name, @SDate, @EDate
2 SP2 @Name, @Max
3 SP3 @Name
Param_Value
SPID Index Value
1 1 ABC
1...
I am new to SQL server 2005 and I need to create a stored procedure to do the following:
I pass a unique reference [MyID] that returns a single record. from the table. This contains the follo...
There is a table with a Last Name field. There are several people with hyphenated last names.
I need to design a query that only displays only the characters after the hyphen.
Example...
I need to run a query that joins two tables from two different databases.
I am creating a table and adding some constraints in SQL Server 2005. To simplify greatly:
I create Column A, and then Column B
Column A can only be one of two values, A or B, so...
C...
How would I obtain the year from the current date rather than forcing 2007 in the following view when I create it?
Thanks!
Experts,
I have a PO_Detail table with an AutoNumber PK, data type Long Integer.
My select statement starts with Table B and I need to join table PO_Detail.
The problem is this my for...
Hi Experts,
Can I use Split function in SQL statement?
I have values in myTblB.aFldInB as a combination of words and numbers with brackets. E.g. "abcdef (123456)". I want to trim the num...
Hi,
i have a table in TOAD for Oracle, and i need to split some values from 2 columns into several..what i have now is:
RATING value
rating1 100
rating2 200
rating3 300
rating...
Greetings;
I have a stored procedure which includes:
IF OBJECT_ID('dbo.SelectedCompaniesInitial') IS NOT NULL
DROP TABLE dbo.SelectedCompaniesInitial
I believe I am receiving the ...
i have two tables:
table 1:
id1 (identity)
conNum
table2:
id2 (identity)
id1
startDate
endDate
The user will enter a date range. I would like to be able to pull a list of avail...
Hello,
I have a table called AdHoc which contains my main data and I have a 2nd table with just account numbers. I want to delete the accounts from Adhoc Table which are in the 2nd Table. I h...
Greetings Experts,
I have previously opened this question before and closed it thinking it was working. Apparently it isnt.
Here is the orginal question;
http://www.experts-exchange.c...
I'm trying to craft a stored procedure that accepts an integer argument. The integer argument is optional and is initially set to NULL. I need to modify the WHERE clause so that it discriminat...
I have a question in concerns with counting rows. I have two tables
table1
CaseID, UserID, CaseTitle, CaseDescription
Table2
ID, CaseID, CaseNotes
How can I create a stored procedu...
REF is a Text field in Table1
In Query1 - Calculated field --- > Test_Field: IIf([REF]="K","other",IIf(CInt([REF])=1,"One",IIf(CInt([REF])=7,"Seven",IIf(CInt([REF])=12,"Twelve",IIf(CInt([REF]...
I am running SQL 2k SP4. Here's a sample query of what I'm trying to accomplish. It is simplified to highlight the specific issue:
SELECT PN.*
FROM FD__PROGRESS_NOTE PN
LEFT JOIN T4W_SI...
