Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-12 : 08:40:13
|
| Praveen writes "How can i make a querystring inside a Stored procedures return few columns of data which then needs to be inserted in to a table.Thanks" |
|
|
sica
Posting Yak Master
143 Posts |
Posted - 2001-12-12 : 09:56:05
|
| I'm not sure if I understnad what you want but here comes something to start with:CREATE PROCEDURE TestASSET NOCOUNT ONSELECT au_lname FROm AuthorsCREATE TABLE #temp (au_lname VARCHAR(50))INSERT INTO #tempEXEC testSELECT * FROM #temp |
 |
|
|
|
|
|
problem