Viewing 15 posts - 1 through 15 (of 15 total)
Hi both,
Thanks again!
The latest solution works great. I gonna test it with our real-world data.
Regards, Reto E.
October 7, 2014 at 8:58 am
Hi both
Thanks again!
The latest solution works great. I gonna test it with our real-world data.
Regards, Reto E.
October 7, 2014 at 8:54 am
Thanks! Eliminating the cross reference did the job. Your query delivers exactly what I was trying to achieve.
October 7, 2014 at 5:40 am
Yes. But you don't know the level of the CustomerID because you only got a CustomerLink.
(See attachment for the actual hierarchy)
October 7, 2014 at 5:24 am
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...
October 7, 2014 at 4:11 am
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...
August 28, 2014 at 11:25 pm
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)....
August 27, 2014 at 7:15 am
Yes.
I now load the xml-file into a variable with a script task. This works great.
found this with google:
Public Sub Main()
...
July 17, 2014 at 5:58 am
I think Table 1 is missing on the webpage.
Otherwise a very intresting introduction. Thank you.
October 1, 2012 at 1:03 am
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...
March 29, 2011 at 8:06 am
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)....
March 29, 2011 at 3:28 am
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...
March 29, 2011 at 1:45 am
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...
March 28, 2011 at 12:01 pm
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...
January 12, 2011 at 12:18 am
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...
October 25, 2010 at 5:49 am
Viewing 15 posts - 1 through 15 (of 15 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy