So it came up that several of our devs are writing their TSQL entirely in code using ADO.NET and submitting their queries that way.<BR><BR>Initially the idea was sprocs for all inserts, updates, etc..

I have a result set stored in #Results.<BR><BR>Now I need to add MORE records to that #Results table.<BR><BR>The first query selects all of our employees and stores it in #Results.<BR><BR>Now what I ...