Is there a function in SQL that does the same as the Excel 'forecast.ets' function [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

开发者_StackOverflow中文版

Closed 13 hours ago.

This post was edited and submitted for review 11 hours ago.

Improve this question

I have been asked to do forecasting in SQL as previously it has been done in Excel using the forecast.ets function in Excel.

Using exponential smoothing methodology I need to forward forecast member numbers for 3 months based on historical member numbers.

Is there a SQL function that can do this?

I have tried using the Predict() function but am getting a error and it does not seem to work:

SELECT d.*, p.Score    
FROM PREDICT(MODEL = @model
DATA = MemberData AS d) WITH (Score FLOAT) AS p;