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 |
|
jbmeeh
Starting Member
1 Post |
 Posted - 2006-05-12 : 17:16:34
|
| I have defined a recursive cte to find all the versions of a given item. I want to define an outer query to generate a list of items meeting certain criteria. My goal is to generate a single resultset which will contain each selected item followed by all its versions. What's the best way to go about this? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-12 : 17:48:12
|
quote:
Originally posted by jbmeeh...What's the best way to go about this?
If you want help, you will need to provide information that people can work with:1. The structure and contents of your tables.2. The results you hope to get.3. The code you tried already, and the problems you are having with it.CODO ERGO SUM |
 |
|
|
|
|
|
nested query