Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kartdb

    Union or tables in Teradata

    Do we have a limit on unions or tables in teradata?
  2. kartdb

    select in teradat

    I have a query wich goes some thing like this... select count(a.dept),count(a.emp) from ((select Distinct 1,2,3 from (select 1,2,3,4,5 from dept) as a) as b; 1,2,3,4,5 are columns... When I run this query,it is giving me the error,table/view/procedure a does not exits... I there any wrong in...
  3. kartdb

    select in teradat

    I have a query wich goes some thing like this... select a.dept,a.emp from ((select Distinct 1,2,3 from (select 1,2,3,4,5 from dept) as a) as b; 1,2,3,4,5 are columns... When I run this query,it is giving me the error,table/view/procedure a does not exits... I there any wrong in my query or...
  4. kartdb

    NCR Teradata Select case

    Thank you it helped...
  5. kartdb

    NCR Teradata Select case

    Thank you for the reply.... What I wanted is not the relation between the two.I want to validate separatly both the values but should come in one SELECT STATEMENT... ......
  6. kartdb

    NCR Teradata Select case

    THIS IS A SAMPLE QUERY BUT MY QUERY LOoKS ALMOST THE SAME...I am getting the 2646 no more spool error..can any one advice me onit select CASE WHEN EMPCD='12' THEN 'SAMPLE' WHEN EMPCD='13' THEN 'SAMPLE1' END AS TEST1, CASE WHEN DEPTCD='12' THEN 'SAMPLE'...

Part and Inventory Search

Back
Top