Hi there,
Please assist with the error -
I have a script like below and getting an error 'Invalid object name 'PayCalendar' '
script -
WITH PayCalendar as (
SELECT
a,
b,
c,
ROW_NUMBER() OVER (PARTITION BY a,b order by c desc) as rn
FROM table
WHERE a=1
)
SELECT
a,
b,
c
from PayCalendar WHERE rn=1
SELECT DISTINCT
ReferenceDate,
(SELECT a FROM PayCalendar pc WHERE pc.rn=1 and ReferenceDate BETWEEN pc.a and pc.b) as PAY_PERIOD_START_DATE,
(SELECT pc.b FROM PayCalendar pc WHERE pc.rn=1 and ReferenceDate BETWEEN pc.a and pc.b) as PAY_PERIOD_END_DATE
FROM table
Many Thanks