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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CROSSTAB - PIVOT IN TERADATA

Status
Not open for further replies.
RAYAARON

RAYAARON

Technical User
Jun 13, 2013
1
US
HI,
I NEED TO DO A ROWCOUNT ON ALL TABLES ON A GIVEN DATABASE. I CAN EASILY DO THIS IN SQL USING A PIVOT TABLE.

CAN SOMEONE HELP?

THIS IS WHAT I HAVE:
LETS SAY THIS IS (TABLE_COUNTS)

TABLENAMES ROWCOUNTS
TABLE1 500
TABLE2 200
TABLE3 800
TABLE4 499

THIS IS WHAT I WANT TO ACCOMPLISH:
LETS SAY THIS IS (TABLE_INPUTDATA)

TABLE1 TABLE2 TABLE3 TABLE4
500 200 800 499


CAN SOMEONE HELP PLEASE. LET ME KNOW IF YOU NEED ADDITIONAL INFORMATION. THANKS.





 
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
186
Teamalone
Teamalone
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
165
johnherman
johnherman
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
320
Miguel93
Miguel93
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
146
tmcrouse
tmcrouse
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
141
jholl
jholl

Part and Inventory Search

Sponsor

Back
Top