SqlCommand comm1;
SqlConnection conn1;
string connectionString1 = ConfigurationManager.ConnectionStrings["DBConnectionString1"].ConnectionString;
conn1 = new SqlConnection(connectionString1);
string sqlcomm1 = "INSERT INTO customer (name, firstname, tele, mobil, fax, email, personno)" +
"SELECT DISTINCT contactperson, Name, Tele, Mobil, Fax, email, PersonNo FROM tem5"+" WHERE (Seid ='" + susid + "')";
comm1 = new SqlCommand(sqlcomm1, conn1);
conn1.Open();
comm1.ExecuteNonQuery();
conn1.Close();

create procedure usp_customer

@Seid int

as

set nocount on

/* TEST SECTION
usp_customer @Seid=11 with recompile
declare @Seid int
set @Seid=11
--*/

INSERT  
INTO    customer
SELECT
DISTINCT
        contactperson name
        ,Name firstname
        ,Tele
        ,Mobil
        ,Fax
        ,email
        ,PersonNo
FROM    tem5
WHERE   Seid=@Seid