Just a suggestion, to get you thinking of another method to use.

Import the CSV data into a staging table, and then using set based T-SQL (for example a Merge statement)...

Try this bit of "spackle" by Jeff Moden ... I believe it might be what you need.

http://www.sqlservercentral.com/articles/T-SQL/71550/

jcrawf02 (4/7/2011)

---

Brandie Tarvin (4/7/2011)

---

I got my parents copies of The Shadow radio show for their anniversary many years back. They loved it. It was one of those things they'd listen...

WayneS (4/7/2011)

---

So, what did you'll think of the QotD? I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to...

Stefan Krzywicki

Did you watch Jack Benny and Burns & Allen? It is a shame so few of those shows are still around. I didn't get to see them until decades...

Greg Edwards-268690 (4/7/2011)

---

WayneS (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

WayneS (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

CirquedeSQLeil (4/6/2011)

---

Roy Ernest (4/6/2011)

---

Gail, Low blow aimed at Lynn... :-)...

CirquedeSQLeil (4/4/2011)

---

Well, if you want, we can certainly nitpick it...

Nice question.

And what the QOD is all about. Testing what you do know and / or teaching you new things you did not know.

Spent April 1st driving from northern part of Ohio to the Virginia atlantic coast, all told over 11 hours on the road. So no time to visit SSC....

I found "SQL Server 2008 Step by Step" Author: Mike Hotek

Library of Congress Control Number 2008935428

a good read.

Look at this link

http://www.amazon.com/Microsoft-SQL-Server-2008-Step/dp/0735626049

Last price I saw was 29.99 +...

Examine the permissions granted to the data base role "Public". From Books On Line (BOL)

Every database user belongs to the public database role. When a user has not...

aswani2002 (3/31/2011)

---

bitbucket-25253 (3/31/2011)

---

Test this T-SQL and modify it for the item(s) you require.

This will work in 2005 and 2008

SELECT * FROM sys.dm_exec_connections WHERE session_id...

Test this T-SQL and modify it for the item(s) you require.

This will work in 2005 and 2008

SELECT * FROM sys.dm_exec_connections WHERE session_id <> ...

Alter your T-SQL to:

SELECT p.object_id,

--Add this to your t-sql

object_name(p.object_id) AS 'object name',p.index_type_desc,

--End addition

p.index_id, i.name, avg_fragmentation_in_percent, fragment_count, record_count, page_count

FROM sys.dm_db_index_physical_stats

(@db_id,NULL, NULL, NULL , 'Detailed') p

inner join sys.indexes i

on p.object_id =...

The answer to your question is of course "It depends".

Without your table definition(s), sample data (more than what you have posted) it is almost impossible to give you a tested...