Is this more suitable?

Declare @QtdRptEarnSubjDed00varchar(10)

,@QtdRptEarnSubjDed01varchar(10)

,@QtdRptEarnSubjDed02varchar(10)

,@diffvarchar(10)

Select @QtdRptEarnSubjDed00 = 0,@QtdRptEarnSubjDed01=0,@QtdRptEarnSubjDed02=1,@diff=20

Declare @sqlvarchar(max)

Set @sql = 'UPDATE SOMETABLE

SET ' + case WHEN @QtdRptEarnSubjDed00 > 0

THEN 'QtdRptEarnSubjDed00'

When...

I recommend you check out how to use the import export tools in SSMS. You can also look at learning SSIS to perform the same task or you could...

Nevermind - I finally found it.

This may be of use as well

SELECT SERVERPROPERTY ('edition'),serverproperty('productversion')

Eliminate the string building.

I would also recommend checking out http://www.sqlservercentral.com/articles/Log+growth/69476/ to help you track down the culprit.

You can setup a job to track your growths and capture the query that is at the...

You're welcome.

Late last night I saw a question but didn't respond to it because I was shutting down in the intent of answering it today.

I can't find it anymore.

Anybody see a...

Steve Jones - Editor (3/18/2010)

---

Jeff,

I completely agree with you. The Cert test ought to be HARD, I mean very hard, like how do I fix xxx when it's broken, or...

Jeffrey Williams-493691 (3/14/2010)

---

iamthemanx (3/14/2010)

---

That's interesting, never thought on check the script(s) behind.

I know for sure is a security stuff, the way SSMS2008 is reading that from the SQL2005 instance....

Now it's everybody else's turn 😀

I copy and paste the results. I have not played with other...

Jack Corbett (3/18/2010)

---

For those not on twitter. I took and passed 70-450 today.

It was definitely harder than 70-432, but common sense gets you through it. There...

crookj (3/18/2010)

---

Tomorrow - High of 31...

Is this for the script...

Can we get those...