Several ideas I have here http://www.insidesql.de/content/view/252/

Although it's in German, I'm sure you'll get the meaning. And may I add that I think that this is a job for your...

It might be worth contacting SQL Server MVP Erland Sommarskog at esquel@sommarskog.se. He is usually referenced when it comes to dynamic SQL.

And he is a very friendly person...

No, I'm not aware of a Oracle forum like this.

However, do google for Oracle mailing lists. Several high traffic ones should appear.

Something like http://www.orafaq.com might be useful

Why don't you create a new column that holds the user values (maybe with a DEFAULT of SUSER_SNAME() and put all rowws into one single table? That way some of...

Explain Plan?

This is still SQL Server, not MySQL, right

Post your table structure and the query so far, so we can figure out.

Do a forum search.

I asked the same question some months ago and got an interesting script. But Mr. Murphy came right in so I can't find it anymore.

Jim,

when you write I don't have all information I need, why don't you provide them to increase the chance that someone here on the fora can provide a solution

Strictly professionally...

So, you're doing a crosstab report? Shouldn't the heading be the job of your front-end?

Here is one of the most-referenced tools for this:

http://www.rac4sql.com

Shouldn't be too difficult to combine...

Oh, I forgot...

EOD!

Oops Jim, no need to be that harsh!

You seem to be an application programmer. Your apparent non-understanding of T-SQL and/or RDBMS can be cured if you are willing to.

Good luck...

What is your overall goal?

Read this. I don't think you can use dynamic sql inside a UDF.

Furthermore I think your whole approach isn't optimal. You should use the appropriate datatypes to store...

Running the usual maintenance stuff should be sufficient.

Since you haven't posted the whole code and your call, one can only guess.  Take a look at BOL at OUTPUT parameters -> Returning Data Using OUTPUT Parameters. I suspect the...