Skip to Content (Press Enter)
UserImage.jpg
Jessica Alessandra de Jesus Marques
13Views
3Comments
Solved
SQL from "EventCalendar" - Forge
Question

Hello, 

I'm trying to implement this forge application, and replicating the preparation "EventCalendar", but I'm having trouble understanding this syntax. 
And This error appears. 

What should I do to solve?


Best regards, 

Jessica Marques

0
0
06 Aug 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP
Solution

Hi Jessica,

In the SQL query, you missed the SELECT statement after the WITH clause...


SQL Snippet

with yearlist as
(
    select 2010 as year
    union all
    select y1.year + 1 as year
    from yearlist y1
    where (y1.year + 1) <= YEAR(GetDate())
)
select year from yearlist order by year desc;


Hope this helps you!


Regards,

Benjith Sam

1
0
07 Aug 2020
Copy Link
UserImage.jpg
Jessica Alessandra de Jesus Marques

Benjith Sam wrote:

Hi Jessica,

In the SQL query, you missed the SELECT statement after the WITH clause...


SQL Snippet

with yearlist as
(
    select 2010 as year
    union all
    select y1.year + 1 as year
    from yearlist y1
    where (y1.year + 1) <= YEAR(GetDate())
)
select year from yearlist order by year desc;


Hope this helps you!


Regards,

Benjith Sam

Hello Benjith Sam,

 Thank you so much for your help, it worked perfectly.

 Regards, 

0
0
07 Aug 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

Jessica Alessandra de Jesus Marques wrote:

Hello Benjith Sam,

Thank you so much for your help, it worked perfectly.

 Regards, 

You're most welcome :)

Glad I could be of help!


Regards,

Benjith Sam

1
0
07 Aug 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.