Viewing 15 posts - 1,306 through 1,320 (of 3,221 total)
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)...
April 7, 2011 at 3:54 pm
Try this bit of "spackle" by Jeff Moden ... I believe it might be what you need.
April 7, 2011 at 12:26 pm
jcrawf02 (4/7/2011)
Brandie Tarvin (4/7/2011)
April 7, 2011 at 12:15 pm
WayneS (4/7/2011)
April 7, 2011 at 10:46 am
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...
April 7, 2011 at 8:12 am
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)
GilaMonster (4/6/2011)
Lynn Pettis (4/6/2011)
Star Trek (the Original)My mother loves both that and Thunderbirds.
Gail, Low blow aimed at Lynn... :-)...
April 7, 2011 at 7:20 am
CirquedeSQLeil (4/4/2011)
WayneS (4/4/2011)
Well, it looks like I (finally) got a QotD question that didn't have everyone up in arms over it... whew!
Well, if you want, we can certainly nitpick it...
April 4, 2011 at 4:03 pm
Nice question.
And what the QOD is all about. Testing what you do know and / or teaching you new things you did not know.
April 3, 2011 at 10:11 am
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....
April 2, 2011 at 10:30 am
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 +...
March 31, 2011 at 3:11 pm
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...
March 31, 2011 at 1:53 pm
aswani2002 (3/31/2011)
bitbucket-25253 (3/31/2011)
This will work in 2005 and 2008
SELECT * FROM sys.dm_exec_connections WHERE session_id...
March 31, 2011 at 12:48 pm
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 <> ...
March 31, 2011 at 12:00 pm
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 =...
March 31, 2011 at 8:45 am
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...
March 31, 2011 at 7:44 am
Viewing 15 posts - 1,306 through 1,320 (of 3,221 total)