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 ?
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...http://www.sqlservercentral.com/articles/T-SQL/62867/
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is usually not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs