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 Grade: A 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 Grade: A Views: 4
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
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 Grade: A 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 Grade: B Views: 5
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
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 Grade: A Views: 43
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 Grade: A Views: 202
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 Grade: A Views: 53
I have to match phone numbers from my table to data in the table below: sales_contact
The phone number is in two seperate fields tho -
prim_bus_ph_area_cd = area code
prim_bus_ph_nbr = 7 digi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23072523.html
