thank you, i just never thought of views as part of the solution and i think it might work.

i was blinded by thinking the other way around, store the...

it's possible to pass dinamic sql to the procs, but imagine that a proc is huge, the main select inside is huge. i dont want to do the entire main...

i think there is something wrong in there .... but probably i wasn't clear enough

i don't need to use a dinamically defined table (which phisicaly exists inside the database) in...

thank you for your answer,

i thought that because i select only 3 columns from the second table it will go faster then simply

select

from hugetable inner join bigtable_i_only_need_three_columns on ....

thank you,

i never thought to query sysobjects for the default

this is only to add some simplification to our sql code at the cost of performance i guess.

the computed columns are calculated every time we query the table, and because...

tell me the language ... it depends a lot on the language.....

thank you for your answers

does the derived table make a big difference? i dont know ....

because all your answers were server solutions ... i will choose the server (procedure, table,query) solution instead of...

because i wanna reuse the plan (or maybe i am completely wrong) of at least for a big part of the sql, and then simply requery the result with some...

thanks, it looks exactly what i need

lets suppose that the applications returns some data for partners, products, field agents, accounts (and 10 more categories), each categories is shown in a grid in which the user can...

thank you both for your posts. I'm sure that its gonna work in both ways, but i was HOPING that maybe im missing an easier way. I imagined that there...

thank you, i never thought of that, i was too busy tring to catch several PRINTS,

and one extreme solution was to write an extended procedure to send some packets...

i was trying to avoid the creation of a table every time i use the select .... but if this is the only solution .... it can be done

thank for...