Hi.
I want to over-write a table in Sql using a select / update or whatever is most relevant.

My Vfp Code would be:

Set EngineBehavior 70
Select * ,Sum(Turnover) as Turnover, Sum(Cost) as Cost from Table1 into Table Table2 Group by Country, City
Sele Table1
Zap
Appe from Table2

Suggestions in C# with Sqlserver woudl be appreciated
Regards,
Gerard