|
Replies:
1
-
Pages:
1
-
Last Post:
Nov 3, 2011 7:55 AM
by: golimar
|
|
|
Posts:
1
Registered:
8/25/11
|
|
|
|
Pivot tables to views?
Posted:
Aug 25, 2011 6:12 PM
|
|
|
Hi,
I love Toad! I recently had a need to create some sort of pivot table view and I opened query builder and created exactly what I need!
The question then is, how can I make this a view? There is no underlying SQL that I can find.
I need a view that looks exactly like the pivot table I see on the screen.
Thanks!
|
|
|
Posts:
7
Registered:
11/3/11
|
|
|
|
Re: Pivot tables to views?
Posted:
Nov 3, 2011 7:55 AM
in response to: alienz
|
|
|
You can use a temporary table instead of a view, depending on why do you want a view...
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
