Looping is definitely not the way to go about this. It is painfully slow. If you are trying...

Something like this?

declare @MyString varchar(max) = '----A375475960dkgjfkfkgjfkvkl!!!!!-------DAfkdfk55500---!'

select len(@MyString) - len(replace(@MyString, 'a', ''))

sql_jr (5/20/2011)

---

If I was sure how to go about this, I would have posted my code. I don't have any b/c I need help. I figured this is...

You should NOT use a loop for an update statement. Try something like this.

update MyTable set Gender = case Gender when 'M' then 'F' when 'F' then 'M' end

You know editing your original post and creating a new thread for the same thing isn't going to generate any new help. Your data is too sensitive and the question...

Like I said, if you want us to help you, you have to provide us some information. There are very few cases where set based logic can't replace a cursor....

GSquared (5/20/2011)

---

I've spent a lot of time recently fixing bugs caused by a prior database dev who didn't actually understand SQL as well as he thought.

For example, an insert that...

We have the occasional bug (where something actually doesn't do what is it supposed to do) but most of the time it is changing requirements. I can't begin to count...

I figured that when I saw

at the very top.

If you really want some help you need...

That won't really get what this guy is after. For example that would turn '17' into '182'. You probably just need to

update table set col = '82' where col...

brent 82845 (5/19/2011)The Primary key for the main table is (Supplier, Terminal, Branded, Product, Eff_Date, Eff_Time)

You can see in the data that Supplier2 sent a second price change for the...

This would get you the whole row.

select MyTable.*

from MyTable

join

(

select GroupID, max(DateStamp) as DateStamp

from MyTable

group by GroupID

) groupList on groupList.GroupID = MyTable.GroupID and groupList.DateStamp = MyTable.DateStamp

order by MyTable.GroupID

Depending...

When establishing a connection if the username/password is correct but the password is set to expired sql will raise an error that the login in failed.

Login failed for user '[user...

Is there a question here somewhere?

You kind of missed the whole point about posting ddl and sample data that is...