I see a relavent article and it seems like table variable is much faster than temp table.

Ref: http://sqlserverperformance.idera.com/uncategorized/performance-comparison-temp-tables-table-variables-sql-server/

:unsure: Confused on which one is better?

hi, I dont know the permenant or a good solution. I think you can split the sql into two vars. and try to execute them like.

declare @sql varchar(max)

set @sql='somequery'

declare @sql1...

weitzera (12/30/2008)

---

I doubt I'm saying anything not contained in that document, but my first impulse is to tell you not to use dynamic sql.

Depending on what you're trying to do...