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 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 executed the following Proc code:
EXEC SQL update locomotive
set
last_poll = SYSDATE
where
locomotive_id = :l_data.locomotive_...
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...
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...
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 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...
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...
With the statment below--I get a error message:
INSERT INTO [SPIResConv5].[dbo].[Transactions]
([TRXNO],
[RESORT_ID]
,[TRANSTYPE_ID]
,[BILLC...
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...
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 guys
I have a table cus_demographic from which I need values from a column code baes on a customer id
The problem is that for a partcular customer is the code can have more than one value...
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
Customer just bought new server under emergency conditions - old server died - we managed to get the databases off
Setup new server
brought in databases
connected to our mfg database wi...
I have a sql server, and in the mssql$hq\backup folder on the HDD it is takigng up much space. There is only 10 gb left on the drive. In that folder are a buch of .bak files that are about 2g...
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...
Hello all,
One would think that after reading all availabel documentation, Wikis and Google searches one would find the answer to this simple question, but I have not.
I am editing a data ...
we currently use a program that uses a database in SQLBase 7.6.1
it takes a considerable amount of time (up to 30 seconds) to import to excel with ODBC
it takes considerably more time to run...
I have a table as follows:
ID Code
A01 111
A02 112
A03 112
A04 113
A05 114
A06 114
All the code are in the ran...
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...
Hi,
Is it posible to filter the user access in SQL 2005 by tables? If it is, how can I do that? As of now I only filter it by database.
Thanks
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...
