Can be CTE referenced within view?

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

The quickest way to answer that question is to try it. 😛

Yes, a CTE can be used in a view. You should then be able to reference the view in CR.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Olga Nitskov SSC Eights! Points: 873 More actions · Answer 2

Thank you Jason for the reply.

I can't find examples CTEs within views. Tried to create - CTE has to be started with WITH and semicolon before! I am really confused, trying...

Has somebody some examples of views with CTE within??

Thanks very much!

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 3

CREATE VIEW dbo.cte_view_test

AS

WITH cte_test

AS

(SELECT id, val FROM dbo.test)

SELECT

id,val

FROM cte_test

Where test is your table

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 4

Here you go. This is using AdventureWorks. Have fun:

CREATE VIEW y

AS

WITH x AS (SELECT *

FROM [HumanResources].[Employee]

)

SELECT * FROM x

GO

SELECT * FROM y

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Olga Nitskov SSC Eights! Points: 873 More actions · Answer 5

Thank you Grant Fritchey

Busy with another urgent issue. I will have fun later.

Thanks!!

noeld SSC Guru Points: 96590 More actions · Answer 6

Hmmm I think I saw this request before 😉

* Noel