Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: SQL
Divers
Thread ID:
00510223
Message ID:
00510228
Vues:
18
Thanks Andrew

Is there an equivalent utility in SQL Server that I can use? Thanks

Best Regards
>Have a look at the CrossTab generator that ships with VFP. It's referenced by the system variable _GenXTab.
>
>Cheers,
>
>Andrew
>
>>I have a patient table and a visits table.
>>Patient
>> Patient_ID
>> Name
>>
>>Visit
>> Patient ID
>> Date
>> Treatment Type
>> Amt
>>
>>I wish to write a SQL statement that will generate a cursor as follows
>>
>> Patient_ID, Name, Amt_1, Amt_2, Amt_3
>>
>>where amt_1,amt_2,amt_3 are expenses incurred for treatment type 1, 2 & 3 respectively. The output is actually sort of crosstab. All help appreciated. Thanks.
>>Best Regards
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform