SQL INSERT INTO SELECT with variable?

[XeNz]

I am trying to execute this SQL INSERT Query but not having any luck. The variable value @sUID is not in the source table so I am trying to add it as a parameter. What is the best way to accomplish what I am trying to do here?Using stCon As New SqlConnection(ConfigurationManager.ConnectionStrings("SeedTrackerConnectionString").ConnectionString)\[code\] stCon.Open() Dim sInsertCommand As New SqlCommand("INSERT INTO [SeedTracker].[dbo].[Revisions] ([STID],[LID],[UID],[isCross],[isMutant],[Genotype],[TVal],[SEQ],[NumLabels],[Label],[ExpName],[Plant],[Type],[Plasmid],[Cultivar],[Container],[Source],[Notes],[CrossExpName],[CrossExpDesc],[Mother],[Father],[LabBook],[Pages],[ELBURL],[Mutagen],[isTrash],[RevUID],[TimeStamp]" & _ "SELECT [STID],[LID],[UID],[isCross],[isMutant],[Genotype],[TVal],[SEQ],[NumLabels],[Label],[ExpName],[Plant],[Type],[Plasmid],[Cultivar],[Container],[Source],[Notes],[CrossExpName],[CrossExpDesc],[Mother],[Father],[LabBook],[Pages],[ELBURL],[Mutagen],[isTrash],@sUID,[TimeStamp]" & _ "FROM [SeedTracker].[dbo].[SeedTracker] WHERE STID = '" + sSTID + "'", stCon) sInsertCommand.Parameters.AddWithValue("@sUID", sUID) sInsertCommand.ExecuteNonQuery() stCon.Close() End Using\[/code\]TIA,Andrew