Have Errors with the following CTEs in SQL SERVER 2008 any help.
;WITH GRAD_MOLD AS
(
SELECT PAYCURRT.IDNO ,
PAYCURRT.FNAME AS FNAME ,
PAYCURRT.LNAME AS LNAME ,
(PAYCURRT.FNAME)+' '+(PAYCURRT.LNAME) AS DESCPTN ,
(PAYCURRT.LEVEL1) AS LEVEL1 ,
(PAYCURRT.GRADE) AS GRADE ,
PAYCURRT.ANUWAGSAL AS ANUWAGSAL ,
PAYCURRT.MTHWAGSAL AS MTHWAGSAL ,
PAYCURRT.EARNTYP AS EARNTYP ,
GRADBULD.TRANCODE AS TRANCODE ,
TRANSAC.CATEGORY AS CATEGORY ,
TRANSAC.DESCPN AS DESCPN ,
00000.00+TRANSAC.VALUE1 AS VALUE1 ,
(TRANSAC.FPVALUE) AS FPVALUE ,
TRANSAC.DMPERCENT AS DMPERCENT ,
TRANSAC.BASWAGCON AS BASWAGCON ,
TRANSAC.TAXSTATUS AS TAXSTATUS ,
(TRANSAC.SSFCAL) AS SSFCAL ,
'NO' AS SPEC_TIME ,
00+1 AS STAT_MTH ,
0000+2001 AS STAT_YR ,
00+1 AS END_MTH ,
0000+2001 AS END_YR
FROM PAYCURRT
LEFT JOIN GRADBULD ON PAYCURRT.GRADE = GRADBULD.CODE1
LEFT JOIN TRANSAC ON GRADBULD.TRANCODE = TRANSAC.CODE
WHERE TRANSAC.CATEGORY <>'UNIQUE'
)
; WITH GRAD_RESULT AS
(
SELECT IDNO,GRADE,LEVEL1,TRANCODE,DESCPN,CATEGORY,VALUE1,FPVALUE,BASWAGCON,
TAXSTATUS,SSFCAL,DMPERCENT,DESCPTN,
SPEC_TIME,STAT_MTH,STAT_YR,END_MTH,END_YR
FROM GRAD_MOLD
WHERE
IDNO + LTRIM(TRANCODE) NOT IN
(SELECT IDNO + LTRIM(TRANCODE) FROM XTRANS_COMB WHERE CATEGORY = "UNIQUE")
)
ERROR MESSAGES
Msg 102, Level 15, State 1, Procedure sp_pers_trans, Line 135
Incorrect syntax near ';'.
FROM PAYCURRT
Msg 102, Level 15, State 1, Procedure sp_pers_trans, Line 147
Incorrect syntax near ';'.
FROM GRAD_MOLD
What am I do wrong ?
>
What I have tried:
There are codes in Sql Server 2008 and having Error messages