Your SQL string should read

SET @sql='SELECT @lvido=lvid FROM ' + @tbl + ' WHERE lvid=''' + @lvid + ''''

You want the variable to be part of the string that...

You seem to be missing the line where you declare the SQL string.

Yup, that'll work too, just a matter of where the variables...

You never give @lvido a value, which means it is null. concat a null into a string and you get a null.

Regardless, I think...

the sql passwords are stored (in encrypted form) in syslogins, which is found in the master database.

Why do you want to use the SQL users table for authentication, not your...

Could you please post the script of your view, tables and constraints. It's easier for people to help if they know exactly what you're doing.

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.