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

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

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

asp.net mvc - breakpoint on javascript in CSHTML? -