Recursive Query

Question

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

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

RyanRandall SSChampion Points: 13623 More actions · Answer 1

I guess your google is broken.

"A recursive query is one in which a CTE references itself."

http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/[/url]

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

SSC Guru

Points: 53873

April 15, 2008 at 6:52 am

Trouble with your homework?

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Or, you can have a procedure call itself. That too is recursion. Triggers can call themselves too. That's usually referred to as "an error."

😀

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

GSquared SSC Guru Points: 260824 More actions · Answer 4

Dictionary definition of "Recursive":

Recursive (re-cur-siv) adj: See recursive.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

RyanRandall SSChampion Points: 13623 More actions · Answer 5

GSquared (4/15/2008)
Dictionary definition of "Recursive":
Recursive (re-cur-siv) adj: See recursive.

😀

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.