I must be going blind. I stared at that statement for several minutes and didn't even notice the from was missing.

Oops, my bad. Sorry.

No disrespect or insult was intended.

The piece End derived table "D" should be preceeded by a -- (it's a comment, not part of the query)

SELECT D.CUSTNMBR,sum(d.SLSAMNT) AS Total

 (

  SELECT CUSTNMBR,SLSAMNT FROM RM20101

  WHERE CUSTNMBR LIKE 'A%'

  UNION ALL  

  SELECT...

I hate to point out the obvious, but CAST('A102' AS INT) gives 'Syntax error converting the varchar value 'A102' to a column of data type int.'

Thanks, that makes sense.

What about the self-blocking? It's not having any visible effects on the server, the commands aren't running for very long, though they do run often (They're an...

Got a suggestion, but it depends on what the data looks like.

This won't work is you have values like A10B54 or 10B10 but is fine if the entries are...

The points are for boasting rights, nothing more.

I would imagine the 21 points was a mistype that will be corrected as soon as Steve notices.

I assumed that the database did exist, and hence restore with replace was required, because there is a use Mydatabase right before the restore.

If the database didn't exist, then the...

Agreed.

I didn't get the reason that REPLACE wasn't required.

Agreed.

I didn't get the reason that REPLACE wasn't required.

Wierd........

?????

Are you asking what it means, what you can do about it, why you got it, or something else completely?

To have got that...

Yes, SQL's looking for a table-typed variable called @dbname1 to update, since an update statement must target a table, not a varchar variable.

More important is what are you trying to do?

If...

You missed my point. If you don't FETCH before going into the WHILE, you don't know the value of @@FETCH_STATUS since it is GLOBAL for ALL cursors on a connection....

Nononono The location of the fetches is correct. You left out a necessary BEGIN... END construct. That's why the execution didn't stop.

You must fetch before going into the loop or the...