What are the challenges you face when working across database platforms? Take the survey
Options

Sql Server 2012 function parsing error

jsongjsong 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

Comments

  • Options
    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
Sign In or Register to comment.