Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Update Salesforce with a parameter

I'm trying to figure out how to pass a parameter to update a record in Salesforce. I am trying something like this based on some googling, but I can't get management studio to accept it:

Update OPENQUERY(SALESFORCE, 'Select Id, Num_of_Reg_Left__c From Asset where Id = ''''' + @SF_Id + ''''''')
Set Num_of_Reg_Left__c = @NumRegLeft

I'm going by this from the documentation:

Update OPENQUERY(SALESFORCE,
'Select Id, AnnualRevenue from Account
where Id=''00130000005ZsG8AAK'' ')
set AnnualRevenue = 4000

Any help would be greatly appreciated! Thank you!
1 person has
this question
+1
Reply