If what you did over there would be considered being harsh, I'd have to stop posting!!

The effort you put in goes...

Good...

@brainblower13

Assuming you'll provide some ready to use sample data (based either on the code snippet Ken provided or by following the guidelines in the first article referenced in my signature)...

Glad I could help. 😀

I expect you understand how it works, otherwise you shouldn't run that code (like any other code based off the internet).

Example: what would need to be...

Dave Ballantyne (11/16/2010)

Since this is a stupid nonsensical restriction 😉 , heres mine

Use denali

select * from...

What's so funny?

Based on the "rules" you prvided, the IDENTITY approach is valid.

@craig-2: I like your reply regarding your availability 😀

@Learner1: insert the data into a table with an IDENTITY column and do a SELECT WHERE ID= 3 😛

Something like this?

USE [AdventureWorks]

SELECT

STUFF(

(SELECT ', ' +name

FROM sys.columns

WHERE OBJECT_ID=OBJECT_ID('Person.Address') FOR XML PATH('')

),1,2,'')

Try to get some (mental or physical) distance between you and the stuff that overwhelmes you.

Keep in mind that it's still YOU who controls those things. Set priorities based on...

Chris Morris-439714 (11/15/2010)

Thanks Jeff, I appreciate the heads-up. I'm disappointed that Karthik hasn't bothered to respond, even if only to say "it doesn't work for me" or "how does it...

It depends where you want to see the output of the job.

Here are some options (most probably there are several more...):

1) create a table to hold the error messages and...

Did you try to google it?

"ssis import csv" did return some very useful links...

I my understanding of Sunils blog is correct, you don't need to add any TABLOCK hint when using Trace Flag 610.

You might even be able to laod the data in...

You describe your current solution instead of the problem you're trying to resolve. Maybe the total approach of using three temp tables can be replaced alltogether.

What I'd like to see...

Here's a most probably much faster approach using the TallyTable based DelimitedSplit function.

DECLARE @tbl TABLE

(

customer INT, seller VARCHAR(50), visits VARCHAR(50)

)

INSERT INTO @tbl

SELECT 1000,'Dan Jakobsen','04;06;08;10;12;14' UNION ALL

SELECT...