I have two tables I'd like to join using Teradata SQL:
Table 1 Table2
Number Score Score_Time Number New_Score Sco...
I am using VB6sp5, and ADO 2.7. I would like to know how to join two SQL tables on two seperate databases with one SQL statement. Is there a way to do this?
Hi all.
I have two table below that I have created.
create table medreason
(
membid int,
lastnm varchar(50),
ident int
)
create table medreason_bak
(
membid int,
lastnm varc...
I have a table with 3 columns as follows:
USERID Date SurveryScore
123 01/01/06 120
123 ...
I tryed to run Maintenance Plan wizard to create a backup job but I get an error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dial...
I executed the following Proc code:
EXEC SQL update locomotive
set
last_poll = SYSDATE
where
locomotive_id = :l_data.locomotive_...
I have a following business requirement where I need to calculate the sum of dollar amount in diffrent dates range:
1. Calculate the sum dollar amount difference b/w yesterday and day before ...
With the statment below--I get a error message:
INSERT INTO [SPIResConv5].[dbo].[Transactions]
([TRXNO],
[RESORT_ID]
,[TRANSTYPE_ID]
,[BILLC...
I need a query that will look in a complete database (100 tables) with different columnns in each. Some of those tables have a column named "name". (not all of them)
I want every entry with...
I have been charged with Disaster Recovery design for a company running an iteration of ADP on their server that uses SQLBase Server 7.5.1 S for its databases. Using Backup Exec 11D, I've bee...
XPSP2 w Office 2K3. Access 2003 Front End, SQL 2000 SP4 Back End. I have to know why my fix worked here. I had a trial balance report that worked fine until yesterday we started getting ODB...
i get error message when i try to run my Sql script in my win app form.....
i get exception message saying thath:
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
...
Hi-
I am using the SAS v8
I want to know if I can use poc SQL for date additions i.e. I want to add 365 days to a start date and creat a enddate. Can I use the normal formart MMDDYYYY + 365...
Hi
I am moving a few dbases from one SQL 2000 server to another.
I understand how to move these via backup/restore; however, I also need to move the logins etc.
How do I go about this...
Hi,
I am running "SELECT" statement to output sales order year nad ordered date by quarterly using following statement:
SET DATEFORMAT mdy
SELECT DATEPART(yy, OrderReceivedDate) AS OrderY...
I'm completely new to SQLBase. How to I find out what data tables are in the database?
Something like (Oracle) "select table_name from user_tables where num_rows>0" ?????
I'm having difficulty connecting to an SQLBase database (1-user Licence SQLBase v. 7.5.1). I'm trying to use the latest .NET DataProvider (from Gupta, installed "typically") to no avail. I hav...
Hi,
I need to select SQLBase 6.0.1 data into a readable Excel file. I know I'm travelling back in time a few years here, but anyone know a way?
Thanks,
Jake
I would like to create job or sp that clears data from a table called dbo.mytable and the DB is called TEST.
I can do so manually but i would like to automatic this, here is what i run to c...
I need to know how to list the index name (and their attribute) on a given table of a SQL databases.
show index? which table name to assign?
thanks
I have ran out of room on the c: drive but I have plenty of space on d: drive
how to I move and configure sql to look for the database on D: drive?
Sql version 8
running on a windows 20...
How does one eliminate duplicate rows from a query?
One of the columns has many duplicate values. I require to pull all the table A rows with the exception of Table A's column col2 contain...
How can I connect to Pervasive SQL from windows Excel; what drivers do I need, I am looking for ODBC drivers but Pervasive website says it is provided with original sofware, Is there any place...
Hi there,
I think that posting the SQL error would help really... so here it is:
27/8: lmsulk: End of illegal lock count dump --------------
--------------------------------------------...
Hi,
I have a list of databases that resides on remote computers. I have access to computername/servername, IP-address and database names for each database. And what I want to do is to connec...
