Hi Everybody,
I'm beginer in SQL and was wonder if anybody could take a look at this and help me. I got this error, and not sure how to fix it.
This is the error:
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'AS'.

Any help so much appreciated
[code=sql]
with [RDR SUB]
as(

SELECT [close_week_num], [product_desc], [team],
[CAST(RIGHT([tech_code],...