Sql Server 2012 function parsing error
jsong
Posts: 2
Hello,
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?
Thanks,
Jian
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
FROM mf.HistFactor
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?
Thanks,
Jian
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
FROM mf.HistFactor
Comments
Red Gate Technical Support Engineer