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 Wanet Telecoms Ltd 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: *

  • Users: kartdb
  • Content: Threads
  • Order by date
  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

    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