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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-24 : 08:44:10
|
| Judy writes "Currently I have inherited the below codes that runs off of a form and then loads the values into the form and then from the first form you call a second form to print out the report. What I would like to do is move this all to the SQL Server 2000 and use a user defined function or store procedure to create a temp table and print the report directly, rather than going to through a series of forms. Any thoughts? - new to the whole T-SQL world. Just seems like there should be a quicker way of handling this.My table is set up as - DogID SireID DamID19 2 77 11 992 15 9If I select DogID 19I need to run a generation code for 8 generations and the SireID and DamID are both also held in the DogID field. My Report has fields of DOG01 through DOG63 and it is possible to have nulls at any point after the initial dog. How do I get the potential values for DOG01-DOG63?" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-24 : 09:09:37
|
and what is the desired out put for you query?? 15 9 11 99 2 7 19 or what?Corey |
 |
|
|
|
|
|
Pedigree / recursive update