This is starting to sound like a homework project. What have you tried so far? Your original post said that it was a 1 column table that was...

I think you want to pivot on the [11Item Date Closed] column. The column names shouldn't have spaces in them. Try this

Create table #t

([3Marketplace Order ID] [nvarchar](138) NULL,

[1Request...

Do you have any examples of the XML you are currently using? What have you tried so far?

I tried this and it works. What am I looking for?

If the results don't matter, then why do it? What if there is a 3rd entry for Canada? What are the results supposed to be?

Here's a...

why are you using a script task? It can be done in an Execute SQL Task. Also, it should probably be performed through calling a stored procedure and...

This looks like a nicely disguised ad. Doesn't belong here.

basically, what we do is create an Archive table and a worktable in the same layout as the partition. These tables are created in the same filegroup as the...

What does it say in the Windows Event Log? What login are you using to start the service?

what are your counts? my guess would be one of them is null, so it will never get into either of your if statements.

I'm not really sure what you're asking. This while loop will continue looping through all records until the rowcount <> 10000. Presumably, the last insert will only add...

The Charindex finds the location of the first comma, you just need to subtract 1 from it

Declare @t table (Name1 varchar(30))

insert into @t

values('Rondo, Rajon'),

('Garnett, Kevin'),

('Allen, Ray'),

('Pierce, Paul')

SELECT ...

You can either use a While loop to insert the records or create an SSIS package and set the Maximum Insert Commit Size on the component. Just beware that...

It's possible that there is a deadlocking issue going on. How often does the proc get called? Is it possible that the update is running into locked records...

Do you have an example of the XML data you are working with and then your expected results?