siddharthak024 (11/25/2015)
for example :with cte1(id) as
{
select query ..............
union all
select query.............
join some query ................
join cte1 on some query
}
how to replicate this logic into normal sql query
I would really appreciate if anyone can crack this logic
Thank You
You haven't provided enough information to answer your question. Recursive CTEs are simply a way to accomplish a given task, just like any other "method". The problem that it's being used to solve will determine what (if any) alternatives are available.
If you care to provide a specific query & sample test data, odds are someone here has an alternative.