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...

It works with even Edit: odd numbers as well...

You'd just have the most right bit set to 1 as well (2^0=1). Basically starting your "Power table" with 0 instead of...

Let's see what I can do...

Using your example, 46(base10) can be written as 101110(base2). Agreed?

Let's start with...