Well , its not that simple for us. We use a product called DeltaSql to generate these sqls. I have no control and no knowledge of that product. On top...

Back from holidays, Happy new year first.

I tried that during my calls with customer but that did not help. Customer had a schema name of the format 'xyz/zyx', and i...

Trying something like this, one can get schema_name prefixed dynamically

Declare @sc nvarchar(500),

@sql nvarchar(4000),

@parmDef nvarchar(500)

select @sc = (select schema_name());

--set @sql = N'select * from ' + '['+ @sc +']' + '.add_yourtable_name'

--set...