Hi,

I'm new with sybase and I'm using ASE 12.5.1.

I want to copy data from many tables by using variable for table name in FROM clause.

I found in this forum that I can use following command for variable table name:

exec ('select * from ' + @tablename)

But my question is, how about the data copy, is it possible to do like following:

exec ('insert desttable
select col1,col2 from ' + @tablename + ' where mycondition ')

I did it but there is nothing in the destination table after that.

If someone can advise.

Does select col1,col2 from ' + @tablename + ' where mycondition return any data?

Thanks for the reply.

Yes, if I give a value to @tablename I get result.

It's the same for

exec ('insert desttable
select col1,col2 from ' + @tablename + ' where mycondition ')

when I fixed in advance the value of my variable, means:

select @tablename = 'myvalue'
exec ('insert desttable
select col1,col2 from ' + @tablename + ' where mycondition ')

I got data copy into "desttable". but when I put this command inside a loop command, the copy is not working.

Then it's something wrong with your loop

Hi,

Thanx a lot for your support. It's working fine now.
You're right, there was something wrong with my loop command.