Hi all,

I have to work with a database in which the company is a part of the table name, so for instance tables Customer01, Customer02 and Customer03 store the Customer of company 01,02,03

Suppose that each user have to work with his company, so I need to inject the Company into the query

"select * from Customer" + user.Company + " where ....."

Which is the best approach at it?



Solution

Hi,

You have to use a expand inline parameter to complete table name.

Solution