How can I redirect the output of SP_COLUMNS to a #temptable?
I'm writing a generic stored proc that 'scans' through the columns in a table. I know that SP_COLUMNS will return a list of column info for a table...but I haven't figured out how to redirect it to something that I can scan through. Any ideas?