Sql Server 2012 function parsing error

[jsong]

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

[andy.campbell.smith]

Although SQL Source Control will work with SQL Server 2012 and SSMS 2012, it still has trouble parsing functions that are new in SQL Server 2012. We're working on supporting the new functions, but for the time being there's not really much I can suggest here - we don't have a version of SQL Source Control that can handle this syntax right now. Sorry!
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer