Native compiled stored procedure in SQL Server 2014, update table joining anothoer one for values -


in sql server 2014, can't work native compiled stored procedure. possible modify code below table updated values table?

create procedure [dbo].[bsp_setmincompetitorprices_mo]     @spid int,     @mincompetitorsprices dbo.bt_mincompetitorsprices_mo readonly native_compilation, schemabinding, execute owner begin atomic     (transaction isolation level = snapshot, language = n'us_english')     update          otu     set         otu.competitorpricenat = mincp.mincompetitorprice              tt_offerstoupdate_mo otu      inner join         @mincompetitorsprices mincp on mincp.concreteproductid = otu.concreteproductid              otu.spid = @spid end 

getting error:

using clause in delete or update statement not supported natively compiled stored procedures

i understand that, there workaround this?

thank you


Comments

Popular posts from this blog

php - Passing multiple values in a url using checkbox -

compilation - PHP install fails on Ubuntu 14 (make: *** [sapi/cli/php] Error 1) PHP 5.6.20 -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -