tMSSqlRow with table name to define

[Anonymous]

Hi,

I would like to create a table under MS Sqlserver with a fixed name like :  customer+context.value

My context value is the category of context : int, dev, rec, prd

I've try

"select * into customer \""+context.value+"\" from customer"

This will create customerint like customer.

Thank you for your help i'm a little bit lost with simple and/or double quotes.

[Anonymous]

Can you please describe more about what you want?

[Anonymous]

As i said in the post, i would like to do : For exemple a table name like "customer" and information from my active environment context : exeample : Context Env = dev (for development

select * from customer+context Env  dynamically => select * form customerDev  

[akumar2301]

Hello 

"select * form customer" + contextStr

[Anonymous]

Hi

The environment context should be selected before the job execution, however, the value of context variable could be changed at run time.


Regards

Shong

[Anonymous · Accepted solution]

Hi,

Don't work.

I'm trying to copy the table customer to a cutomerDev table

like this :  select * into customer"+context.Dev+" from customer" ;

but there is something wrong in my request with the context Var

I've tried : select * into customer \""+context.Dev+"\"  from customer" ;  but it don't work

[Anonymous]

It works fine now, sometimes to mutch quote kills the request. Then I just modify with

"select * into customer\"+context.Dev+\""