Can you put the procedure that does the insert on the linked server itself?

Sure!

On the remote server:

create procedure proc_name ( @col2 int, @col3 varchar(20), @record_id int output)

begin

set nocount on

declare...

Check Entegra.

It is going to cost you but it does exactly what you need.

HTH

Yes but you will need to cycle the service after that.

for more info go here

HTH

Definetly That's one way for more go here 

HTH

>>I observed the second query returning results faster

SQL is a declarative Language you tell it what you want but you have little control on how you get it

It -...

Mike,

There is no such a thing like the first PK or the second PK.

Think about it like the first or the second can only be determined by an order by...

 can't create a temp table because of the varying number of columns

Yes you can:

Create Table #Tbl1 ( i int)

 declare @xx varchar(1000)

set @xx =  'Alter Table #Tbl1 add col1 int'

exec(@xx)

set @xx...

There is something not clear yet. If one of them violates the uniqueness how do you know which goes to B and to C.

In other words if you have...

if you convert your procedure to a function you will be able to do it pretty easily:

Update Set Colx = coalesce ( sv.TextValue, dbo.YourFunction(xx),'-')

from...

But I think you should have to take a...

This is a CLASSIC connection problem. I am going to give you three possiblities / workarounds

1. When you use VPN, generally NT Authentication credentials are not passed to SQL Server...

1.I hope you don't have access allowed directly to SQL Server from the internet. If you do cut it immediately

2. Follow mom suggestion. Firewalling traffic at least only from the DMZ...

MEMORY and STORAGE are good candidates on where to start. if the system is going to be used as OLAP then 64 bit may be also considered. Without doubt a...

Because I don't know the purpose of this. This is what I would recommend:

--Drop it

select * into TableName_bk from TblName

DROP Table TblName

-- Recreate it

Select * into TableName from TblName_Bk

DROP...

Adding to Kenneth,

When you filter on the "ON" you still have values on the outer( in this case "properties" ) table. When Filtered on the where you are efectively removing...

There are several very unconfortable ways to this in the back end, which I never recommend. You will have a happier life if you concatenate those columns in the Front End.

HTH