Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can PIVOT do this ?
Message
De
25/05/2010 15:08:47
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01464982
Message ID:
01465949
Vues:
32
>>>>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.....
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform