Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2009-03-19 : 20:38:12
|
OK - maybe this has already been answered - if so - apologies.I'm after some code which will parse my Access queries and recursively expand all subqueries so that instead ofselect * from x where x is another Acess query - I getselect * from (select bla from bla) x This would be really useful for porting Access queries to other databases and other SQL formats.Anyone seen anything like this?--I'm not schooled in the science of human factors, but I suspect that surprise is not an element of a robust user interface. |
|
|
|
|
|
Recursively Expand Subqueries