ALTER PROC foobar
SELECT clientID, Nm FROM client
CREATE TABLE #foos (clientID INT, Nm VARCHAR (255))
INSERT #foos (clientID, Nm)
SELECT * FROM #foos
-- DROP TABLE #foos
Joe's Knowledge Base - A Collection of Various Tips-N-Tricks (Software) that I really get tired of having to find again each time I need them. Now ... where did I (put/find) that ...