C#

Session["userName"] = "JMQ";
// create a new SqlConnection object with the appropriate connection string
SqlConnection sqlConn = new SqlConnection("Data Source=localhost;Initial Catalog=Cost_Model;Integrated Security=True");

//Open the connection
sqlConn.Open();

String result;

//Create unique ID
SqlCommand sqlComm1 = new SqlCommand("SELECT newid()", sqlConn);
SqlDataReader ID = sqlComm1.ExecuteReader(CommandBehavior.CloseConnection);

//Close the connection
ID.Close();

sqlConn.Open();
SqlCommand sqlComm2 = new SqlCommand(
    "SELECT * INTO ##tempFAR15_" + Session["userName"] + "_" + ID + " FROM FN_FAR15(1)",
    sqlConn);
SqlDataReader r = sqlComm2.ExecuteReader(CommandBehavior.CloseConnection);

r.Close();

Response.Redirect("FAR15.aspx");