|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
insert into table from stored procedureI think I've seen this before but am not sure. Is there a way to insert rows
into a table from a stored procedure? For example, I'd like to run sp_spaceused and output the values to a table. This is the idea: SELECT EXEC sp_spaceused 'customers' INTO #tablestats. I know that doesn't work but is there a syntax that will? Obviously if a procedure returns more than one result set (like sp_spaceused does when no parameters are passed) this presents a problem also. Keith  |
|||||||||||||||||||||||
Other interesting topics