如何在我的SELECT（T-SQL）中使用变量

I've written a crazy INSERT/SELECT statement that works pretty well, except that I think it can be tuned a wee bit more if I can avoid using the statement th