Thanks.

Thanks

lucky guess. I could only think of 3...

"your answer will never be wrong if you read the related subject first" is not my experience!

I might miss out on gaining a point getting it wrong but...

Easy one!

I got it wrong 🙁 but learnt something new. Thanks.

Interesting question. Thanks.

I too thought there might be a change in 2012 and that is was a trick question. 🙂

I'm glad it wasn't.

Thanks.

hbanerje (6/5/2012)

---

I have facing problem with one practice rate which is printing in green supposed to print in black because A_NatlRate and A_75NatlRate are each 0.0

how...

SQLKnowItAll (6/4/2012)

---

It doesn't make sense what you are doing. Why are you trying to use dynamic SQL when there is nothing dynamic there?

Just do this:

set @MaxTotalidade = select convert(bigint,isnull(max(cod_sincronismo_fim),0))

from...

Looks like you have a misplaced quote at the end and you're missing a closing parenthesis.

You could try a trace to see how long its taking to complete one batch. With that and the total number of records you expect to be deleted, you...

Since your select returns over 3000 records, your next step would be to test the 'if' condition.

Could your db have been imported from some other dbms? Might explain those extra files.

Regardless as Steve already advised those additional filegroups can be removed.

Thanks for the question.