i fixed my own problem
the events where not showing when a regular user was logging in but when admin logged in they started popping up
and said :
Driver Apple LaserWriter Select 360 required for printer Apple LaserWriter Select 360 is not installed on the server. Contact the administrator to...
same problem here with apple laserwriter select 360
printer is on lpt1 with a certified ms driver. option to share is set.
in fact when i create another bogus lpt2 printer (hp lj 4050) it would not share either
drives share ok
remote computer doesnt have any events in event log to the effect...
i found out what the problem is - but i still don't have a solution.
looks like the sort is getting hang up on a lot of 0's. in one case i have about 100k rows of sales = 0. if i eliminate these rows, query runs fine, but if it's just the zero's, it freaks out. i tried nullifzero() but it...
Hi all,
I'm trying to get deciles for a large file about 20-30 million recs. I'm running out of spool space on the sort part. Is there any way i could improve my sorts?
This is what i do. first, i get sums of sales per client. then, i assign deciles to the sales. finaly, i compute max, min, avg...
can i do something like this somehow?
declare x float;
set x = select count(*) from t1;
i want to use x as a row count in several places in following queries in my procedure.
thx all for your previous responses!!!
thx this maybe actually solve more then i asked for
after i create a macro where does it reside and how long does it stay there, is this a one time deal or can it be stored for x time
question 2
if date is not specified can it assume current date somehow?
how can i define and use variables?
I have a query with a bunch of hardcoded dates. i'd like to replace them with a variable, which i can define before the query. I'm running a simple query batch.
%var1% = '2001-01-01'
select * from t1 where dt = %var1%
something like this.
is there a ref for teradata anywhere? Please dont just say info.ncr.com or teradata.com because i cant find anything there and some resources are pswd protected.
my immediate questions is how to subtract two dates. i need to get the number of days between max(dt) and min(dt).
this what i use...
I was writing some queries on my local sql srv and am trying to translate them into tera now. the problem is with select statements inside the main query such as this -
SELECT x.cust_id,
(SELECT SUM(tot_sal_amt)
FROM table1 a
WHERE date < '1/1/2001' AND a.cust_id = x.cust_id)...
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.