Hi,

I use table name as input parameter of SQL Query to select data from external table and try to execute query.

I got the error as below.

Errors message :

Invalid object name 'CoABT.dbo.CoCounter'.

My Query: 

Select @EntityName.* From @EntityName

Input parameter (Expand Inline set to Yes) :

"{CoCountersABT}"

---------

I try with other Query

Query:

SELECT {CoCountersABT}.* from {CoCountersABT}

It work.

I checked the generated query in Executed SQL. It's the same both.

Executed SQL:

 Select  [CoABT].[dbo].[CoCounters].[Id], [CoABT].[dbo].[CoCounters].[ColumnName], [CoABT].[dbo].[CoCounters].[Counter], [CoABT].[dbo].[CoCounters].[Filler1] From  [CoABT].[dbo].[CoCounters]

So can we use table name as input parameter to dynamic query??

Thanks,

Hung