Database

<br />
SET STATISTICS TIME ON<br />
-- Query here<br />
SET STATISTICS TIME OFF<br />

<br />
declare @temp table (col1 int, col2 int, col3 int)<br />
insert into @temp values(1,3,20)<br />
insert into @temp values(2,6,512)<br />
insert into @temp values(1,2,23)<br />
insert into @temp values(4,9,429)<br />
insert into @temp values(3,8,92)<br />
insert into @temp values(4,7,35)<br />
insert into @temp values(2,9,1)<br />
<br />
select t.*<br />
from @temp t<br />
inner join<br />
( select col1, min(col2) as col2<br />
  from @temp <br />
  group by col1<br />
) d on d.col1 = t.col1 and d.col2 = t.col2<br />

DECLARE @collist varchar(1000)
DECLARE @formatted varchar(1000)

SET @collist = 'col1,col2,col3';
SET @formatted = '[O_' 
                 + REPLACE(@collist, ',', '] [nvarchar](MAX) NULL,[O_') 
                 + '] [nvarchar](MAX) NULL';
PRINT @formatted;

Sunset Towers wrote:

the information that is being inserted is being retrieved from a CSV file

Sunset Towers wrote:

I'm not sure how I could pass that table directly into the SQL Server to do the SELECT INTO

Sunset Towers wrote:

Also there is a need to do some pre-processing on each record before it's inserted