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 |
|
Indyyan
Starting Member
31 Posts |
 Posted - 2004-07-08 : 10:10:57
|
| Orderposreg.Ordernr = #Temp.Ordernr,Orderposreg.Pos = #Temp.Pos,Orderposreg.Produktnr = #Temp.Produktnr,Orderposreg.Artbenämn = #Temp.Artbenämn,Orderposreg.Artikelgrupp = #Temp.Artikelgrupp,Orderposreg.Förs_pris = #Temp.Förs_pris,Orderposreg.Kvant = #Temp.Kvant,Orderposreg.Total_Intäkt = #Temp.Total_Intäkt,Orderposreg.SSort = #Temp.Sort,Orderposreg.Datum = #Temp.Datum,Orderposreg.Utskriven = #Temp.Utskriven,Orderposreg.Levtid_Ö = #Temp.Levtid_Ö,Orderposreg.Levtid_L = #Temp.Levtid_L,.....Orderposreg.lastcol = #Temp.lastcolFor every row i have such failure messagesMsg 107, Level 16, State 2, Line 1The column prefix '#Temp' does not match with a table name or alias name used in the query.Server: Msg 107, Level 16, State 1, Line 1The column prefix '#Temp' does not match with a table name or alias name used in the queryThis is the text from Microsoft HelpUse the column prefix that corresponds to the exposed name of the table.Rewrite any queries where column names are qualified with the table name. Use the table alias instead.Do anyone have a idea?? |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-07-08 : 11:01:32
|
| Is this ASP? |
 |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-07-08 : 11:01:35
|
| Not sure what you're trying to say. Where is the table created? Where is the FROM statement in the query?A local temporary (one # sign) table is only available to the connection that created it. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-07-08 : 11:04:51
|
| Cross post...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37206 |
|
|
|
|
|
|
|
|
Error Message 107