0 - 5 of 5 tags for #SQLAssistant

Hi,
How can I get "Select * from tablename" result in alphabetical order of column names in SQLA window ?
Ex. Table/view has columns defind in order A,C,D,B , then sel * from table should show columns in order A, B ,C ,D.

Hi All, I have the given query as below. There are nested query A,B,C using same tables for joins just the entities joined are different each time. The problem is query is not optimized and does not run in database for more records. For few records gives correct result. Can somebody help me here.
 

I get the Error 2616 (Numeric overflow occurred duing computation) when I run the code below.  I developed 2 separate queries that each run.  When I put them in one query and use a UNION I get the error message.  1 side of the union returns 274 records and the other side returns 277 records.  I'm using Teradata SQL Assistant when I get this message.  We a

CREATE SANDBOX.SC2_VDGB  (
  MAIN_ID VARCHAR(12)  
, PLAN_NBR VARCHAR(9)  
, MEMBER_NAME VARCHAR(64)  
, CASE_NBR VARCHAR(9)  
...
, X8 VARCHAR(1)  
, XB VARCHAR(1)  
, XC VARCHAR(1)  
, XD VARCHAR(1)  
, DAHS_FACILITY_PROV_NBR VARCHAR(12)  
, DAHS_FACILITY_NAME VARCHAR(64)  
, PRODUCT VARCHAR(2) 
) 
PRIMARY INDEX (MAIN_ID);