Sql Server 2012 function parsing error
I have a stored procedure with the following code which works in sql server 2012, but after checking into TFS, I'm now getting a parsing error on the "commit Changes" tab. I'm guessing it has something to do with the Percentile_cont function because it's new in sql 2012. I had to comment out this code in TFS so that the commit changes tab can work.
I'm using version 3.0.13 which should be compatible with 2012. Any ideas?
INSERT INTO mf.Pct (EffectiveDate, pL, pH, Low, High, ID)
SELECT Distinct EffectiveDate, @count, @count + 0.1,
PERCENTILE_CONT(@count) WITHIN GROUP (Order by Value) OVER( PARTITION BY ID,EFFECTIVEDATE),
PERCENTILE_CONT(@count+0.1) WITHIN GROUP (Order by Value)
OVER( PARTITION BY ID,EFFECTIVEDATE) Pct, ID