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 |
|
dhoenig
Starting Member
1 Post |
 Posted - 2007-10-12 : 12:34:21
|
| Has anyone ever had this experience? I have a SP that has four main pieces: 1) Creates a temp table that fills itself from a select statement. 2) Update the temp table based on another select statement.3) Delete records out of a different table that will be filled next.4) Insert records into the table we just purged in step 3 from a select statement with joins (which includes our temp table).When we run it 1 step at a time it runs fine, but when it runs as a whole in a SP our interactively it just spins forever. Has anyone had this experience before?Thanks! |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-10-12 : 12:40:51
|
| Do create use CREATE TABLE #temporSELECT *INTO #TEMPFROMJim |
 |
|
|
|
|
|
stored procedure problem