To get you started, you'll want to use a ForEach container and the FileSystem task. Exactly how you would use them, I don't know off the top of my...

Looking at BOL, it looks like you use just like a table.

I would still load the data into a temp table before doing the join.

😎

Take a read of BOL. I think I have seen this before, and you may need to use OPENROWSET.

😎

No. He asking if you can add the table you want to join into the stored proc and join it to the other tables there.

😎

You need to populate a temp table with the results from the stored proc and then join to the temp table. Unfortunately SQL Server does not let you treat...

I'd need a little more specifics. The table DDL, smaple data (in the form of insert statements that can be cut, pasted, and executed to populate the table), and...

I'll agree, you have a process that is working, you don't need to change it unless your requirements change.

One of the things I sometimes needed to do was restore a...

That sounds like a good script for the script library.

😎

I was manually zipping backup files using PKZip. and it did a great job. Problem was: 1) it was manual, and 2) it was time intensive.

Using HyperBac cut backup...

First, Steve probably hasn't seen this thread yet, as he may be off at a conference. I know that when he learns about an issue such as this,...

Personally, I'd leave it in the existing table. If you move it to a second table, then you have to create an outer join to the secondary table to...

smunson (6/25/2008)

majorbloodnock (6/25/2008)

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and...

Then I will make the assumption that you'll be the first to volunteer to vet future QotD and willing to stick with it through thick and thin. I would...

I another thing is that instead of complaining about wrong answers to QotD and demanding points back because the answer(s) were wrong (as in this case) or the question was...

Hows this:

with PlayerWins (

PlayerID,

Wins

) as (

select

Player.PlayerID,

sum(isnull(ScoreCard.Finished,0)) as Wins

from

dbo.Player

...