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