I have an Access Database that has 2 linked tables from a Teradata Database
Datasource:
Name: SDW
Description: Data Source for SDW
IP Address:
12.44.53.283 (sedwp3-8.ddc....
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21112446.html
Zones:
MS AccessDate Answered: 09/01/2004 Rating: 9.4 Views: 0
how do i change this teradata code to work in sql 2000
( trim(consult.first_nm) ) || ' ' || ( trim(coalesce(consult.middle_intl,' ')) ) || ' ' || ( trim(consult.last_nm) ),
http://www.experts-exchange.com/Database/Miscellaneous/Q_21430076.html
Zones:
DatabasesDate Answered: 05/23/2005 Rating: 7.6 Views: 0
Hi,
I need to export data from Sql Server 2005 to Teradata.
Could anyone provide me the steps for doing the same. Thanks in advance.
Arun
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23589000.html
Dear Experts -
I am trying to capture the datatypes of each column in a list of tables in Teradata. What is the best way to do this - is there some SQL command I can issue from QueryMan?
T...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_245...
I have a table that I want to append the records to a table on a SQL server. NCR Teradata (Standard ANSI SQL)
This is a ACCESS Date field to SQL table Date field(Format 'yyyymmdd'). Using an a...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20247968.html
Zones:
MS AccessDate Answered: 01/05/2002 Rating: 7.0 Views: 0
Hello,
Howto speedup the connection between a msaccess client app. and NCR-teradata table.
I use ODBC for linking.
Because the table i use is different everytime, I can't use a static link.
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20360347.html
Zones:
MS AccessDate Answered: 09/19/2002 Rating: 4.4 Views: 4
I have a table with the following rows
Custnm InternalId parent Other-cloumns
abc 01 p1
abc 02 p2
xyz 03 p1
I need the output giving all...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20579109.html
Zones:
MS SQL ServerDate Answered: 07/04/2004 Rating: 7.2 Views: 0
I have a teradata ODBC connection. I need to change the password for this every 30 days, so I wanted to create a job on my MS-SQL server that could fire a SP on the teradata server to update my pas...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21716523.html
Zones:
DatabasesDate Answered: 02/07/2006 Rating: 9.0 Views: 54
I am having trouble getting the top 10 rows in Teradata.
This is been complicated by a couple things:
1. I don't have permissions to create a temporary table.
2. I am using a group by funct...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21896402.html
Zones:
DatabasesDate Answered: 06/23/2006 Rating: 5.4 Views: 211
Does anyone know a way to filter out non-numeric characters in a char field?
I am looking for something like the following that works with Teradata:
Select * from table where IsNumeric(field1)...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22059012.html
Zones:
DatabasesDate Answered: 11/13/2006 Rating: 9.4 Views: 51
