Update dbo.MyTable

set Column = replace(Column, 'ABCDEF', '')

where Column like 'ABCDEF%';

Does that get what you need?

Oh, and if this is for homework, you could also potentially use a loophole in the exact wording of the question, and build a cursor with an Order By in...

You could do something stupid like:

select max(Salary)

from MyTable

where Salary <

(select max(Salary)

from MyTable

where Salary <

(select max(Salary)

from MyTable

...

Are all the rows getting the same update? If so, modify the Where clause to include all the rows you want.

If not, what are some sample rows?

I've used maintenance plans in SQL 2005 and 2008. Haven't used them in 2008 R2 yet. They work well enough for shotgun maintenance. They do backups well...

SSIS FTP object doesn't do SFTP, as already mentioned.

I used WinSCP for this when I had to do it a little while back. They actually have a documentation page...

It's part of the max objects.

Ron, that'll work if you're processing one row at a time.

If you want to query a set of rows of data, add a Where clause that checks that the patindex...

I bet they loved the line about a laptop!

Glad you got it working.

First, variables are batch-specific. You can't have a batch separator ("GO") between declaring and using. That's your biggest problem. Fix that first, see if you still have...

Jack Corbett (11/15/2010)

---

Grant Fritchey (11/15/2010)

---

I actually don't have any good advice on this one. I can tell you that going to a SQL Saturday, or better still, the Summit, has...

Jack Corbett (11/15/2010)

---

GilaMonster (11/15/2010)

---

How have I, or how do I think (looking back) I should?

i have a partially written blog post, just trying to decide if i want to expose...

Take a walk around the block and look at the scenery for burnout. Trust me, it works. Sometimes takes a few laps.

On overwhelm, pick something that you can...

The people who...