InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:51:53 GMT20http://www.sqlservercentral.com/Forums/Topic809445-145-1.aspx[quote][b]martin.edward (10/27/2009)[/b][hr]Hello,I am in the process of creating a recursive query, but have no idea on the basics i.e. recursion,looping through sql statements etc.Could some give me a drill down ?[/quote]The only time you should use recursion is for hierarchies. The only time you should use a loop is for flow control across tables or databases... that leaves out 99.9% of all queries.Rather than learn the wrong way to do things by learning recursion and loops first, take a look at the following article for an alternative to needing most loops...[url]http://www.sqlservercentral.com/articles/T-SQL/62867/[/url]Wed, 28 Oct 2009 21:00:46 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic809445-145-1.aspxIf you're interested in how the recursive queries work, seehttp://sqlblog.com/blogs/linchi_shea/archive/2009/04/16/recursive-sql-queries-how-do-they-work.aspxWed, 28 Oct 2009 03:28:54 GMTdmoldovanhttp://www.sqlservercentral.com/Forums/Topic809445-145-1.aspxYour question is pretty open-ended. It would help us in helping you if you could provide more specifics regarding your problem. Please take the time to also read the first article I reference below in my signature block regarding asking for assistance. if you follow the instructions in that article you we get much better answers to your questions.Tue, 27 Oct 2009 11:14:34 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic809445-145-1.aspxHi,Can you give a llittle more info on exactly what it is you need a loop for?For the time being have a look at the following article (SQL Server 2005, wont work on 2000)[url]http://msdn.microsoft.com/en-us/library/ms186243.aspx[/url]Tue, 27 Oct 2009 10:45:02 GMTLewis Dowsonhttp://www.sqlservercentral.com/Forums/Topic809445-145-1.aspxHello,I am in the process of creating a recursive query, but have no idea on the basics i.e. recursion,looping through sql statements etc.Could some give me a drill down ?Tue, 27 Oct 2009 10:17:54 GMTmartin.edward