Search results for query: *

Right you are jgerstb (Didn't think about the different users re-creating the same view over and over again). I guess that leaves only the 3 choices. Performace as of yet is not bad so I guess I will choose one of the options and hope for the best. Thanks Dirk Lieske

Sorry, Please Replace the word USERID to = USER. The intention of my question was not to focus on the USER part, but thanks for pointing/telling me about USER (Which Teradata recognizes) and USERID (Which Teradata does not). What I was really trying to ASK is: WHICH VERSION OF THE SQL WILL...

I am not certain of your question: IF you are asking: How long does it take for data to be loaded into a Teradata Database from a file? Then it really depends on the ratio of hardware to your filesize and how well you write your ETL. So my answer is it depends, however I will say the strait...

I would like to do the following in SQL: (My goal is to be as efficient as possible in a View not a macro or procedure) IF (Userid = 'BOB') SELECT * FROM table A WHERE Condition = 1 IF (UserID = 'BILL') SELECT * FROM table A WHERE condition = 2 I know I could write the above as...

I don't know why but I know what. You are seeing a vertical tab which sometimes shows up as a line feed. What editor are you using to look at you output? Cheers Dirk

Hi, I am trying to select 1234 from the following field: XXX1234XXX Basically I want to select the numbers and leave the characters behind any sugestions? Also the characters may or may not be there and they may be differing lengths. Thanks in advance.