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 - 2003-07-08 : 07:16:32
|
| mahesh writes "i'm encountering Line 121: Incorrect syntax near '#TRA_HIS_RES_SALES_WITHALL'. where the above temp table is created at runtime using a transaction table. the SP was working fine until a new field ( a numeric field)was added to the transaction table and the SP updated according to the added fieldhope someone can throw some light on it as i can't picture out the mistake thanx in advancemahesh" |
|
|
dsdeming
479 Posts |
Posted - 2003-07-08 : 08:04:18
|
| I think we really need to see the code if we're going to be able to help you with this.Dennis |
 |
|
|
|
|
|
Incorrect syntax near '.....' error in my SP