deleted

Nice example. Although I have encountered this problem many times and normally start by doing something even simpler, just selecting out the column and then len(column) - if the character...

Agreed, TEXT datatypes are like other datatypes as chalk is like cheese.

However interesting article, a shame it was hard work to read.

The logic here is clearly flawed.

The correct way to perform such an operation would be:

set rowcount 1000
while exists(select * from orders(nolock) where fulfilled <> 1 and status=1)
begin
  update orders
 ...

I agree, this question is bulls**t, the author (like so many who write for this site) should learn the art of proof reading. The...

Basically useful advice, however from experience I would add the following reccomendations.

1. To ensure the correct query plan is used for your SP, I would pass the date range parameters...

Phew what a mess!!

I'll not bother to decipher all that, suffice to say it looks way to bloated for its own good and probably the schema is in a bit...

This is most likely a parameter sniffing issue.

Your proc will run fine if you declare and use a local variable for the query. SET the local variable to the value...

I have used BCP similar to how you are intending to use it very successfully.

Your code however won't work, how do you suppose it will process more than the first...