Hi both,

Thanks again!

The latest solution works great. I gonna test it with our real-world data.

Regards, Reto E.

Hi both

Thanks again!

The latest solution works great. I gonna test it with our real-world data.

Regards, Reto E.

Thanks! Eliminating the cross reference did the job. Your query delivers exactly what I was trying to achieve.

Yes. But you don't know the level of the CustomerID because you only got a CustomerLink.

(See attachment for the actual hierarchy)

Thx ChrisM for your CROSS APPLY approach. I tried something like this, but sometimes cross apply is a bit misterious to me ...

Your solution doesn't work, because you can't assume...

Shredding is a good idea if you work with XML in your database. But here we export a XML from tables of our database to the filesystem. And I like...

Thank you for your post.

We do a lot of XML exports with SSIS. And it works great.

Is it possible to get a formated xml output (readable for humans with linebreaks)....

Yes.

I now load the xml-file into a variable with a script task. This works great.

found this with google:

Public Sub Main()

...

I think Table 1 is missing on the webpage.

Otherwise a very intresting introduction. Thank you.

WayneS (3/29/2011)

You can probably get improved performance by adding indexes to those temp tables:

1. #zeilen - add index on the zeilentyp and zeilennbr columns (in that order).

2. #belege - add...

Hi all

I was able to dramatically improve the procedure. But I had to rewrite the whole section. I didn't want to do this (since it's not an application we wrote)....

Hi all

I did some further investigation.

When I delete the "zeilentyp = 40" part (see --<<---) of the select statement, I get only about 1'100 reads instead of 110'000 reads!

But...

You're right. Somehow the points and parentheses got mutaded during copy-paste.

I use SQL2008. An the reads come from profiler.

The excecution plans for the queries are also different. The query with...

Thank you for this tip with the STUFF function.

Is the order by in the subquery really needed? I think the for xml does it anyways. If you don't use the...

Well, another question:

How do I use the group filter with "in" in BIDS?!?

If I filter: [custgroup] = 1 - direct sales

or: [custgroup] = 2 - internet sales

the filter works.

But if...