Hi Randall, Put the // on a separate line between the individual statements, not just behind:
INSERT INTO ... // INSERT INTO ... // INSERT INTO ... ... If still some error occurs, try executing only one statement, perhaps it is really a syntax error. Cheers Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Randall Hinton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 19, 2003 6:23 PM > To: [EMAIL PROTECTED] > Subject: Fwd: Sql Syntax Problem, > > > > > > Hello Again, > > I have removed the quotes and added the comment lines > but I am still > > getting the "Invalid End of SQL Statement" Error on this > query, I have > > been running the sql through the SQL Studio if that makes any > > difference. > > > > Current Query: > > > > INSERT INTO ans_curusers (user_id, lic_type, inuse, > session_id) VALUES > > (6, > > 2, '02/14/2003 10:07:02', 23701) // > > > > INSERT INTO ans_curusers (user_id, lic_type, inuse, > session_id) VALUES > > (6, > > 2, '02/14/2003 10:07:32', 23705) > > > > Thanks, > > Randall Hinton > > > > > > You will indeed have to put a // at the end of each > statement (line > > comment). It is used as a separator between multiple > statements but is > > not > > needed when executing a single statement un SAPDB. The "update > > duplicates" > > should be ok though I have never used it myself. > > > > Florian Kaerner > > > > > >> -----Ursprungliche Nachricht----- > >> Von: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED]]Im Auftrag von Randall > >> Hinton > >> Gesendet: Mittwoch, 19. Februar 2003 00:49 > >> An: [EMAIL PROTECTED] > >> Betreff: SQL Syntax Problem > >> > >> > >> Hi all, > >> I am trying to import a Extremely long SQL script from > MSSQL into SAP > >> and I have found the majority of the things that I have needed to > >> change, it creates the Tables fine but when it tries to do multiple > >> insert commands in succession it gives me an "Invalid END of SQL > >> statement" Error... Is there supposed to be some control > character at > >> the end of the statement....? > > > >> Thanks, > >> Randall Hinton > >> > >> _______________________________________________ > > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
