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 ...
Listing 5. This procedure demonstrates a technique for combining an Insert statement and an Update statement into a single stored procedure. CREATE PROCEDURE STDA.CustomersUpdate @CustomerID NCHAR(5), ...