Re: Procedure that select different number of columns

[Zawisza Czarny]

>> how about writing a query that returns to application env table?
>I don't understand that question.

For my app I need other stuff then just parameters and item id's ;) so this query should return also other stuff at once e. g.

item 1 name; number of items; when added; OTHER STAFF ; parameter 1 name; parameter val
item 1 name; number of items; when added; OTHER STAFF ; parameter 2 name; parameter val
item 1 name; number of items; when added; OTHER STAFF ; parameter 3 name; parameter val
item 2 name; number of items; when added; OTHER STAFF ; parameter 1 name; parameter val
...

This have a lot of unneeded data (repetition first x cols) but I don't need to make a pivot table, and I don't need to get rid of EAV table when doing something like this, and I have all needed data in single query.