Hi,

it took me a while so set up a step by step "tutorial" on how to convert a static cross tab into a dynamic cross tab using your sample data...

Would you mind sharing some sample data together with your expected result?

Please see the first link in my signature on how to post sample data.

There are several ways to do...

In general, PIVOT can give you the requested result.

But when looking at your scenario it seems like you don't want to modify your pivot statement whenever you have a new...

To repeat my question from above:

Another question (probably the more important one) would be: what are you doing with the table in question? Is it used at all, and if...

What does "25 lakh" mean? 25.000, 25.000.000 or something different?

If it's 25.000 within two month I wouldn't worry about it. It would take about 7 years until you hit the...

Gus, thank you for the link to Joe's article!

I don't use hierarchies that often so I used to do it the "old fashioned way"...

The article really does show an alternative!

Here's an example on how to convert rows into columns.

-- remove intermediate table if existing

IF object_id('Tempdb..#intermed') IS NOT NULL

BEGIN DROP...

Table structure:

Emp_ID, EmpName, Parent_ID, Offset

001, Bill, Null,0

002, Allen, 001,0

003, James, 002,0

004, Wendy,001,1

SQL logic:

How about splitting the effort?

Your part: providing query to do the standard hierarchy

Our part: we'll help you...

Based on the given data there is no information that Wendy should be at level 3. Why not level 4 or 10?

You probably need an additional column indicating the level...

Since you have a typed xml file, you need to use the NAMESPACE declaration.

I would use T-SQL rather than SSIS though. Therefore I'll show you an T-SQL example:

;WITH XMLNAMESPACES (

...

What would your expected result set in general and especially in terms of handling dups (e.g. for 'AARON K' and 'ENGLISH'?

The issue itself sounds like a task for dynamic cross...

jcrawf02 (10/29/2009)

---

Thanks Seth, I tried to go down that road, but all the examples are using aggregation of some sort, which I wouldn't want to do, just pivot the straight...

Well, that most probably eliminates the "good guy approach" options....

Arguing with a lawyer wouldn't be anything I'd recommend. That pretty much reduces the options to either the...

Elliot brought up a couple issues where you or the cops or the city can't do anything about the stuff that person is doing.

But look at it from the other...

I would try to contact that person and ask in a most gentle way something like

"Would you mind sharing your reason for having that camera up there? I have kids...