Using CS3 - MS-SQL/ASP - HELP USING CTE

[Chamark]

I am attempting to create a record set starting with cte as in my SQL statement. I have successfully ran the statement on the SQL server but DW says I need to start with a SELECT when creating a record set. Any way around this besides creating a stored procedure?

Any help is greatly appreciated

[bregent]

I've never used a CTE with DW, but my guess is that you will need to code this by hand. Other than that, can you use a derived table to accomplish your goal?

[Chamark]

Thanks bregent I'll give the derived table a shot