Hi ,
I am trying to retrieve a data from datatable type variable for specific index and try to insert data into table, but some how i am not able to do it.
SQL Code :
==============================
Declare @Ccount int
Set @Ccount = 0
while (@Ccount < %NewVar%)
begin
Set @Ccount = @Ccount + 1
Insert into "TTable" Select %ExcelData[@Ccount]%
end
================================
here
1. @Ccount is SQL variable
2. %ExcelData% power Automation Desktop Datatable variable
i am trying to retrieve data from specific index from datatable variable %ExcelData[@Ccount]%
but it not working throw Syntax error message.
please do a need full help.
