I just wrote a huge query with temp tables, updates and all. I go to run it, and i'm getting syntax errors. odd... everything looks right on that line. so, instead of exec(@query), I select @query Turns out, its getting chopped. @query is declared as varchar(8000). it doesn't go any higher than that. What can i do? I can't split it, because its one big insert: Insert into #temptable select all the conditional stuff here any ideas? thx.