Hi Lutz,

Thanks for your reply and i couldn't imagine what issue it may cause? But I am more willing to use your suggestion, before that will the below condition work...

Hi Eric,

Thank you so much for your precious time on this post. I agree the proc should work first then considering about the structure

Here is the my try...

Thanks Eric for the confirmation and one more question,

the sample data i posted is having less columns. actually i have 20 columns in the select list. Also the parameters to...

Hi Eric,

thank you and it worked perfect after i changed the sum to avg on the last statement. Quick question, If am not wrong that we don't need group by...

thank you lynn for your reply.

Hi Eric,

Wonderful and thanks for your help. I understand this is little awkward to think. But i have some reason to this in Database. A...

Hi Mister,

Finally i got green flag to go with Linked Server from my client. But for my self learning i will need to try your sample. Thank again for...

Hi mister,

thank you so much for your time on this post and am not sure whats happening on my side as you proved it is working perfectly for you. but...

Hi Micky,

Appreciate your time on this and you sample works fine. but i need to call the procedure instead of this logic because before inserting i will have some logic....

Hi Micky,

I tried that way an hour before and not sure the procedure called twice and the insert statement did twice inserting the records.

any suggestion...

Hi Mister,

I tested the remote procedure on it and it is working perfectly. Also my actual procedure will looks likes the same in my post.i just changed the...

Hi Jeff,

The action what am performing is i need to do some operations on remote server(db) from my production db. The operation will have select, insert,update and delete.

for...

Hi mister,

Thanks for the reply. i tried the way you suggested, no hope,

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Deferred prepare could not be completed.".

Msg 8180, Level...

Hi Jeff,

thanks for your time on this.

What could be the remedy for this issue, any help please

Hi Eric,

it is on my first post. Here is again,

Create Procedure TestInsert(@IdEmployee int, @Name varchar(20))

as

BEGIN

Insert into Emp(IdEmployee,Name) values(@IdEmployee,@Name);

END

Any help please

yes i could do. the normal select statement with openrowset is working fine for me