if @action='edit'
		declare columns_cursor cursor fast_forward
			for select aColumn, name from aColumns where aTable=@aTable and IsAudit= 1 
	else
		declare columns_cursor cursor fast_forward
			for select aColumn, name from aColumns where aTable=@aTable 


	open columns_cursor
	if @@error<> 0  goto ErrorHandler

	fetch next from columns_cursor into @aColumn, @columnname

	if @@error<> 0  goto ErrorHandlerCursor

	while @@fetch_status= 0  begin
		if @mode='old'
			begin
			if @condition is null
				set @sql='insert into ##audit(aTableEvent, aColumn, OldValue) select ' +
					cast(@TableEventId as varchar( 19 )) + ' as aTableEvent, ' + 
					cast(@aColumn as varchar( 19 )) + ' as aColumn, ' + 
					'cast(' + @columnname + ' as nvarchar(4000)) as OldValue ' + 
					' from ' + 
					@tablename + ' where ' + @idcolumn + '=' + cast(@rowid as varchar( 19 ))
			else
				set @sql='insert into ##audit(aTableEvent, aColumn, OldValue) select ' +
					't1.aTableEvent as aTableEvent, ' + 
					cast(@aColumn as varchar( 19 )) + ' as aColumn, ' + 
					'cast(t2.' + @columnname + ' as nvarchar(4000)) as OldValue ' + 
					' from aTableEvents t1 inner join ' + 
					@tablename + ' t2 on t1.rowid=t2.' +  @idcolumn + 
					' and t1.eventid=' + cast(@eventid as varchar( 19 )) + 
					' and t1.aTable=' + cast(@aTable as varchar( 19 )) 
			end

		else
			begin
			if @condition is null
				set @sql='update ##audit set NewValue=(select cast(' + 
					@columnname + ' as nvarchar(4000)) from ' +
					@tablename + ' where ' + @idcolumn + '=' + cast(@rowid as varchar( 19 )) + ')' + 
					' where aColumn=' + cast(@aColumn as varchar( 19 ))
			else

				set @sql='update ##audit set NewValue=cast(t2.' + 
					@columnname + ' as nvarchar(4000)) from ' +
					@tablename + ' t2 inner join aTableEvents t1 ' +
					' on t1.rowid=t2.' +  @idcolumn + 
					' and t1.eventid=' + cast(@eventid as varchar( 19 )) + 
					' and t1.aTable=' + cast(@aTable as varchar( 19 )) + 
					' where ##audit.aColumn=' + cast(@aColumn as varchar( 19 )) + 
					' and ##audit.aTableEvent=t1.aTableEvent'
			end
		 --print @sql 
 
		exec (@sql)
		if @@error<> 0  goto ErrorHandlerCursor
		fetch next from columns_cursor into @aColumn, @columnname
	end