I'm using a Vertica SQL client DBVisualizer to run queries on Vertica. I would like to encapsulate my code. I would want users to just enter couple parameters on my queries and get the results. I read and got 2 options.. 1 UDF's.. since the code returns tables of records and involves temp tables. I ...

Stored result set in a temp table and then used it in formatting. It's all good now. thanks!

I never challenged you for a solution. You took it wrong. challenge was noun there not verb.. Anyways leaving grammar away.. the reason I can't do that brute force is that the result set comes after 2-3 joins on 2 tables so I can't afford to run that same thing 5 more times :( I don't have a solutio...

Need to distinct from both columns and for my first result column and then do a count for respective rows (number of times they are in first place or second).

The challenge in my situation is that the First place Values and Second place values can change depending on the where clause. So I cannot hard code them using Decode.

Hello guys,

Does Vertica support Pivot command?

I was looking to do the following

first Place Second
A A
B B
A B
C A
D C

Transformed to
Places First Second
A 2 2
B 1 1
C 1 0
D 1 0

Any suggestions?