<div>
Provide your data representation in the table with expected result?
</div>


Provide your data representation in the table with expected result?

<div>
<div class="content wysiwyg-content">
I don't know if MSSQL 8 will do this, but here is the issue. &nbsp;I am building a membership system that needs to track up to 3 levels on who recommended whom. &nbsp;Here is a quick example:<br />
Person1 signs up Person2<br />
Person2 signs up Person3<br />
Person3 signs up Person4<br />
In a table I need to show that not only Person1 is resposible for Person2, but also Person3,Person4<br />
It also needs to show that Person2 is responsible for Person3&amp;Person4 as well as<br />
Person3 is responsible for Person4.<br />
<br />
I am not sure if a query will do this, any assistance would be appreciated. &nbsp;By the way this is a webbased coldfusion site.<br />
<br />
<br />
<br />

</div>
</div>


I don't know if MSSQL 8 will do this, but here is the issue.  I am building a membership system that needs to track up to 3 levels on who recommended whom.  Here is a quick example:
Person1 signs up Person2
Person2 signs up Person3
Person3 signs up Person4
In a table I need to show that not only Person1 is resposible for Person2, but also Person3,Person4
It also needs to show that Person2 is responsible for Person3&Person4 as well as
Person3 is responsible for Person4.

I am not sure if a query will do this, any assistance would be appreciated.  By the way this is a webbased coldfusion site.





MS SQL 8 Query

Apple's early computers ran on a variety of operating systems, including a Pascal version and one based on CP/M, before releasing its ProDOS with the advent of its 16-bit computer. With the release of the Lisa, which had its own OS, Apple and computing entered the graphical age; it was followed by the Macintosh, which offered a series of "System" operating systems. Other Mac operating systems included PowerPC until Apple acquired NeXT and folded it into the Mac OS. Current operating systems for Apple devices are Mac OS-X and iOS.

Apple OS

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.