This is my Sql statement which appears on a datareport in vb6. In the database, paymentmethodID is formatted as a number, yet it appears in the database as a string not a number. So when I ad...
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...
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...
Hello everyone,
I have a SQL query in a data source, and some VB code posted below - as I understand it, the query should give me the primary key value of the record that was just inserted....
Dear Experts,
Good day. I am looking for some assistance in building a query. I have a Access 2007 Database having a just one table, namely "CDR". The Field structure of the Table is as fol...
Hi, I have the following string variable that are concatenated in an SQL statement. However, the result is not what I expected, as it does not return records from database.
insertList = "fi...
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 am trying to write a variable length random function in SQL to be used on SQL Server 2005.
here is what I have so far...
Here are the errors...
Msg 443, Level 16, State 15, Procedur...
Hi
I have a quick question about SQL 2005. I want to use a select statement which returns the value of the first record in a specified field. In the old days you could use the "FIRST" sta...
Hi,
iv table which have a date column, in addition to a set of other columns, all what i need a simple select query to get * from myTable where dateColumn value between (Start value) and (En...
I have one table that has a column with a State in it and a second column with multiple states and need to join them:
i.e.
Table One Column Table Two Colu...
I have a table that has a column called FileExtension.
I would like to know a SQL statement that would return two things. Extension and Total Count.
I basically want to group them by ex...
hi everyone i have this query which gives me correct results but i want to change the season column to row header for example right now the query print the results as follow
BRANCH_CODE ...
Currently I have two timestamp in my Firebird database - TxDate and TxTime.
1) I found that when I update this TxTime with my TDateTimePicker.Time value, I saw it is stored as "1/1/1900 2:3...
Can someone please give me the SQL query that will take a single database field that contains a user's full name (John W. H. Smith) and split it up to last name, first name and then order by l...
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...
Hi all,
I have a series of alphanumeric values:
15T Handling Cleat
Cleat 10T Handling
Handling Cleat 5
I would like to extract only the number from the above, so I would see
15
...
I need to design a T-SQL query for a MS SQL 2000 database which can retrieve the following information from a table: TripID, PickUpDate, DriverID, and number of times that the driver has drive...
Hi all,
I have a piece of SQL PLUS code that I am trying to make it work with little success. It is to be executed in a SQL PLUS environment and I need help with it...
The purpose of this ...
I have a table (Products) with the following fields:
Item SKU
Location
Qty
The values are:
Item SKU Location Qty
1234 901 100
1234 902 20
1234 909 8
23456 901 10
23456 902 ...
Greetings Gurus,
I am working in T-sql (MS SQL server 2005)
I am trying to format a datetime field to display in MM/DD/YYYY format. Here is my current select statement;
select distinct...
The follwoing is my sql query, what i need to do is minus 1 day from the date.
Where dtInjury = '" & PickDate & "' the date comes up as 07/28/2008.
how can I subtract 1 day from this d...
select top 10 statspartner.campaignid, statsc.campaignname, statspartner.partnerid, statspartner.pdate, statspartner.kw, statspartner.clicks, statspartner.actions, ((statspartner.actions / sta...
Hi,
Really simple question. I have two tables linked by their ID's. One table is a data dump and the other a refernce table. In the data dump there is arond 4900 records. when I do a query to...
Hello,
I am trying to figure out T-SQL code to parse out an address in MS SQL 2000. Using 123MainStreet as an example, I need to be able to add a space between '123' and 'MainStreet'. If th...
