Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can PIVOT do this ?
Message
From
25/05/2010 15:08:47
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01464982
Message ID:
01465949
Views:
31
>>>>Disappearing for a couple of days I'm afraid. I'll try when I get back. Thanks.
>>>>Viv
>>>
>>>Enjoy your disappearance if it's vacation related.
>>
>>Thanks. It was vacation related (sort of)..
>>The T-Sql in your last post worked fine - thanks for that too. I packaged it up in a SP but I'm using EF and since the structure of the results cannot be known in advance there's no way of providing a mapping. I think I'm going to have to go with Linq to Entities to do the work in .NET.....
>
>The result is going to be ID, Col1, Col2, Col3, ColN. The N is unknown, but if you use number big enough, can you do the mapping?

In a word,AFAICS, Nope :-{
I don't even see a way of authoring my own ComplexType that would do the job.....
Previous
Reply
Map
View

Click here to load this message in the networking platform