not fluent in CTE's but I thought i did this right. I get an Error Near SELECT for the select after the CTE.  Thoughts? thanks  (Sorry, Webpage doesnt give me a SQL option below . . . thanks 
I deleted the SQL, i found my problem, i was missing a ) at the end of CTE . . sorry