Skip to main content
Chamark
Known Participant
January 24, 2011
Question

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

  • January 24, 2011
  • 2 replies
  • 388 views

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

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

bregent
Participating Frequently
January 24, 2011

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?

ChamarkAuthor
Known Participant
January 24, 2011

Thanks bregent I'll give the derived table a shot

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices