Query Table to rename fields and use in GUI Bulk Insert

Queries and Resources
,
4

@Darren that is correct, I was having issues with the date but the main issue ended being the GUI mode not accepting operations with triggers as per this topic response: Mssql insert failing - #2 by joeBumbaca

I needed to get a workaround by having the following steps:

  1. Use JSON to SQL to gather the data from the table.
  2. Get the "OK" button call the query to Insert the records on a temp "bridge" table I created (with a unique Id to make them unique for the user uploading the data).
  3. On success call a stored procedure to get the records from the temp table associated to the unique id and process them mimicking what I had as the trigger. The stored procedure handled the date issue.
  4. On success and failure call a query to truncate the records from the temp table for the id.

Not happy that I needed to go this route but seems to be working fine.

Thanks for following up @Darren

1 Like