1c1
< USE [hwe_navajo]
---
> USE [hwe_navajo_new]
4c4
< /****** Object:  Trigger [hwe].[entity_attribute_value_nd]    Script Date: 06/22/2017 17:19:03 ******/
---
> /****** Object:  Trigger [hwe].[entity_attribute_value_nd]    Script Date: 06/22/2017 17:19:34 ******/
8c8
< SET QUOTED_IDENTIFIER OFF
---
> SET QUOTED_IDENTIFIER ON
16c16
< CREATE trigger [hwe].[entity_attribute_value_nd]
---
> CREATE TRIGGER [hwe].[entity_attribute_value_nd]
23a24
> print 'insert hweaudit'
30c31
<   select d.import_id, ed.import_id, isnull(et.write_report_data,0), hwe.decamelize(et.name), hwe.decamelize(case when java_classname = 'java.lang.Boolean' then 'is_'+ea.name else ea.name end), cast(d.picklist_value_id as varchar), case when java_classname = 'java.lang.boolean' and d.string_value = 'true' then '1' when java_classname = 'java.lang.boolean' and d.string_value = 'false' then '0' else d.string_value end
---
>   select d.id, ed.import_id, isnull(et.write_report_data,0), hwe.decamelize(et.name), hwe.decamelize(case when java_classname = 'java.lang.Boolean' then 'is_'+ea.name else ea.name end), cast(d.picklist_value_id as varchar), case when java_classname = 'java.lang.boolean' and d.string_value = 'true' then '1' when java_classname = 'java.lang.boolean' and d.string_value = 'false' then '0' else d.string_value end
34a36
> print 'open cursor'
43a46
> 	print 'got here'
45,46c48,50
<   set @parameter_definition = '@id bigint, @now datetime';
<   set @sql = 'update report.' + @report_table + ' set ' + @update_columns + ' where id = @id';
---
>   set @parameter_definition = '@import_id varchar(255), @now datetime';
>   set @sql = 'update report.' + @report_table + ' set ' + @update_columns + ' where id = @import_id';
> 	print 'got here2'
49c53,56
< --  execute sp_executeSQL @sql, @parameter_definition, @id, @now;
---
> 	print 'got here3'
> 	print 'sql ' + @sql
> 	print 'import_id ' + @import_id
>   execute sp_executeSQL @sql, @parameter_definition, @import_id, @now;