Follow

How to create a custom table insert

In release 16.7, TimeXtender has added new feature called Custom Table Insert. This feature allows user to add data to a table based on a custom SQL query

To use this feature, right-click the table you want to add data to, select Advanced, and then select Add Custom Table Insert.

 

pic1.png

 

In the script editor, create a SQL SELECT statement - no INSERT clause is necessary.  The script should look like this: 

SELECT 
[FirstName], 
[MiddleName],
[LastName], 
[FullName] AS [Full Name]
FROM [Person]

If the field names in the source tables are different from the field names in the destination table table, use an alias to make the names match up.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.