Select Code to Download

    my $sthH = $dbh->prepare("INSERT INTO Disease_types (Adapted_code)
SELECT ('A'+code) FROM Disease_types") or die "Couldn't prepare query:
+ ".$dbh->errstr;
    
    $sthH->execute() or die "Couldn't execute query: ".$sthH->errstr;

DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL 
+Server]Str
...
. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) at Creating_table.pl 
+line 389
.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlr
+ef/ts_operator_3qov.asp