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

...

Yes, it is a SQL injection attack.

I'd notify the the 3rd party provider of the web application regarding the SQL Injection attack. If it is getting through to your...

Not real sure what you are asking for here. Can you provide a more detailed example of what you are looking for?

😎

Option 2 takes out one of the tables (Event). Not sure what the difference in IO's, execution plans, overall performance on a full production system.

😎

And just for the heck of it, here is more (slightly formatted):

DECLARE @T VARCHAR(255),

@C VARCHAR(255)

DECLARE Table_Cursor CURSOR

FOR...

Here is a second option:

with PlayerWins (

PlayerID,

Wins

) as (

select

Player.PlayerID,

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

from

...

Got to plug HyperBac. We have installed it on 7 servers so far (it is also licensed per server) and it has reduced backup/restore times on these servers as...

How does this look:

with PlayerWins (

PlayerID,

Wins

) as (

select

Player.PlayerID,

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

from

dbo.Player

...

Based on the sample data, what is the expected output? Need something to check our work against.

😎

Well, we need more info before we can really help. Besides seeing the code for you stored procedure, we also need to see the DDL (create statements) for your...