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 |
|
spinningtop
Starting Member
29 Posts |
 Posted - 2012-06-07 : 11:51:55
|
| Hi I have a stored procedure which creates a temporary table then it inserts values into the table, and finally updates the table. However the problem is that if I include these three statements in a statement block with BEGIN / END it will not accept it and throws an incorrect syntax near END message. The problem lies with the last update statement, is it because the insert has not been committed yet? I want the statements all run in one block as the block is part of an if / else procedure. How can do this? thanks |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-06-07 : 11:53:39
|
| post your code<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
CREATE TABLE, INSERT and UPDATE in statement block