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