Access 2000, Access 2003, Access 2007 forms, Access 2007 functions, Access Database, Access Forms Database, Access Functions, Access reports, Clustering, CSV, Data structures, Database administration, Database Backup, Database connectivity, Database design, Database issues, Database management, Database migration, Database servers, DB2 administration, DB2 Universal Database, DB2 Web Query, DBA, DELETE statement, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, Indexes, INSERT statement, IT careers, JDBC, JOIN statement, LOOP statement, Microsoft Access, Microsoft Access subforms, Microsoft Access tables, MySQL, MySQL Database, MySQL query, ODBC, Primary keys, QMF, Query optimization, SQL queries, Sybase, Timestamp, Triggers, UPDATE statement VIEW ALL TAGS
We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...
I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.
I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I'm trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the...