What is the structure of the dataset?

If you can post some sample data, you will get a working solution, but at the moment we have nothing to work with.

Please read the second article found in my...

Actually, the...

Well, the bytes 0x504B usually denote the start of a ZIP compressed file, could be a plain ZIP, could be an office document or some other...

You really should have something...

I will take a look later, but maybe someone else will jump in before then.

Can you explain, with screen shots, how you are trying to connect to a data source, (not a model), and include the exact errors?

It is pretty hard to troubleshoot general...

well, if the NULL issue is so bad, maybe you should ask them to approve and package it?

** Disclaimer **

I do not work for or have any commercial relationship with the authors of this software, nor will I gain any advantage from recommending it.

** End **

Try "SSMS...

Why do you want to pivot this in SQL when Excel could do it for you, then you wouldn't need to mess with column numbers?

BOR15K (7/1/2014)

---

Thank for the reply. I am getting "XQuery [value()]: Heterogeneous sequences are not allowed in '=', found 'xdt:anyAtomicType' and 'xs:unsignedByte'." when I try it.

That said, the requirement has been...

You can use a recursive CTE to generate a relationship table:

(Note: I could not get this to work with your schema collection though, for some reason it complains about the...

What authentication method are you using?

Have you tried forcing TCP rather than named pipes ? (try putting "tcp:" in front of the server name)

You're most welcome, and thanks for making it easy to help you!

In...

Yes, you did a great job of providing a working sample 🙂

What should the correct figure be for that total?