Without using Case, we can do it thru this sql...
select
distinct h.cust_id 'cust',
s1.mins 'March',
s2.mins 'April',
s3.mins 'may'
from
hist_tbl h,
(
select
cust_id,
mins,
mons
from
hist_tbl
where
mons = 'march'
) as s1,
(
select
cust_id,
mins,
mons
from...
If you are going to use VBA for loading data into teradata then set a ODBC connection and direcly load the data from the text file to the table.
If this is what you are look for then I would help (if required) in coding how to pull data out from a text file.
mpx,
There is Workflow Business Objects which contains Business process, Activity, Steps. I'm not sure u r mentioning this no where I find Business Object in Peoplesoft.
Ziggetty has mentioned BusinessObjects which is a Business Intelegence (BI)or OLAP tool basically used for reporting and...
Hi,
U cud find them in MicroStrategy website. But check out the latest version of Business Objects e6 which I suppose has mamy more features embedded on it.
User3000.
HI frankycat,
To connect to Oracle u need to create a DSN for Oracle.. You can create your DSN by
Control Panal->Data Source(ODBC)->System DSN->ADD-> Microsoft ODBC for Oracle. for this u need some component which we get during Oracle Instalation. Here I cant understand where the...
Hi frankycat,
Queryman is not specific for just Teradata Database.. it could connect to any database thru MS ODBC. Check whether your ODBC connection is set properly.
User3000
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.