Home
Populating the transactions table
Before we build the SQL query, we want to populate the TRANSACT table with more data (only one customer has transactions already). To load the records into this table, do these steps:
| In the Data Project Explorer right-click the RAD7DataDevelopment project and select Import Æ General Æ File System, and click Next.
|
|
| Click Browse and locate the C:\7672code\database\samples directory. Select LoadTransaction.sql and click Finish.
|
|
| The LoadTransaction.sql appears in the SQL Scripts folder. Right-click LoadTransaction.sql and select Run SQL from the context menu.
|
|
| The results are displayed in the SQL Results view. For the INSERT SQL statements, the status should be Succeeded.
|