Is it good practice to use temp tables in a view...
Quick Answer: You can't. Views are single statement activities.
You can use cte's to help keep code readable. You can subselect to the end of the earth. But you can't do multi-part statements.
If the question is regarding a global temp table (##tmp)... don't do it. More headaches then it'll ever be worth to you.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA