Hi Eric

The procedure what i am calling is on different server and has only insert statement. am not returning. but i would like if it returns affected rows. Also...

When i execute the above query here is the error am getting

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "

...

Hi Eric,

Soryy for the late reply i was into my customer meeting. Here is what i am getting from the last query,

SELECT * ...

Hi Eric,

Thakns for your reply and when i execute am getting sysntax error

declare @IdEmployee int = 11,@Name varchar(20) = 'Peter';

EXEC('SELECT *

...

can anyone please help me in this regard

Hi Craig,

Thanks for your reply. I will not be using this mechanism often. also i am informed to use non linked server that's why i started to do the research....

Some time mind doesn't working to get easy logic

Here is the way i achieved.

select

stuff

(

coalesce(', ' + cast(@id1 as varchar(10)), '') +

coalesce(', ' + cast(@id2 as varchar(10)), '') +

coalesce(', '...

this is my next try,

set @id1 = 60

select coalesce(cast(@id1 as varchar(10)),'') + ',' + coalesce(cast(@id1 as varchar(10)),'') + ',' +

coalesce(cast(@id1 as varchar(10)),'')

it gives the result as 60,,

I...

Hi Sean and Luis ,

thanks for your assistance. Unfortunately the design couldn't be changed at this moment. I also thought about that. Appreciate your time on this.

Hi piet,

I agree. i already tried with function and it kills the time. thank you for your suggestion. Appreciate your time.

Thanks for the reply,

Yes i do agree. Is there any way to achieve these kind of search functionality? Any suggestion please

I tested. am correct. Sorry to bother.

In terms of speed it is excellent. Thanks for the help. Outer apply logic is excellent and very fast

If am not wrong this will be the query

select

c.IdCompany,

c.CompanyName,

case when oa.CompanyCode is null then c.CompanyCode else oa.CompanyCode end...

Hi Lyn, it is super fast. i have tested on my. but have another query about on your logic, if need to bring the another column of child.

Structure:

Create Table dbo.Company(

...

Thanks Lynn, can i conclude the moral of this comparison that The first logic takes very little time then other two and also faster.

Also i will be testing...