hi,
I have report that is generated from joining three views. one view takes forever which slowes down the overall performance of the report. is it recommended to maybe create that table on the fly as #tempTable then join it with the other views then drop it ?

if yes, can someone give me an code demonstrating how I can create that table, join it with other tables then drop it? thank you very much.

waely