What is the business rule for the values for Introducer,LeftMember, and RightMember?

Yor sample do not show an "easy" pattern...

Example: ID=2 has Introducer=10 but is LeftMember of ID=1.

Edit: Thank your...

Several issues:

1) please provide sample data in a ready to use format

2) include expected result set

3) show us what you've tried so far and where you get stuck

For details reagarding...

Question 1:

Yes...

Bill Talada (1/15/2010)

---

To keep the code sample very small, I cut some corners. The code that "looks" at the surroundings of the robot assumes a square border around a...

Like I said in my previous post:

You have TEXT data type for Nome(text,null) and Empresa(text,null).

It seems like there is some confusion what that data type really is supposed to be...

How would you define a...

Nicholas Cain (1/15/2010)

---

One thing about trying to cast or convert a Zip code to a decimal or int, you'll run into problems where a zip starts with a 0 as...

Since FLOAT is an approximate-number data type, the character length may vary, therewith exceeding the VARCHAR(10) limit.

You need to get the value converted to a "known length".

Either one of...

I would create a view on SQL Server side that transforms the xml data into a table and query the view.

You could also use that statement directly inside SSRS to...

I used Google with "ssis pivot transformation" which brought this site[/url] back as the first hit.

Seems to answer your question....

It would help a lot if you could at least post the complete error message (including error message number). Even better if you could post your table definition.

I'd guess one...

Jeff Moden (1/14/2010)

---

shaini.binu (1/14/2010)

---

[font="Arial Black"]Quote: Am I right that you'd need to start a new group as soon as neither one of the numbers in one row has been previously...

Something like this? (Please note how I set up the sample date to be ready to use for others...)

Even though SQL Server has several ways of getting your requested results,...

I thought about applying the concept of a hierarchical CTE (aka recursive CTE, see BOL for details). Basically, I would have used the smaller ID per row as "manager" and...

Would you mind sharing the business case that would use such a strange data structure?

Regarding your requirement:

Am I right that you'd need to start a new group as soon as...