Thanks, we're currently running SQL 2005 & 2008 on our servers.

Current licensing costs for SQL have not justified upgrading, since we have a fairly low volume, low traffic web application.

You...

Thanks. I think I will use this variant which worked:

EXECUTE ('update P set P.Email1 = Email1 + ''XYZ''

from MyDatabase.dbo.Profiles P

JOIN MyDatabase.dbo.Complaints EC on EC.ID =...

Pulling the whole table back must be the problem. Thanks.

I think I knew that at one point 😉

I was trying this:

update LinkedServer.MyDatabase.dbo.Profiles

set Email1 = 'XYZ'

from LinkedServer.MyDatabase.dbo.Profiles P

JOIN LinkedServer.MyDatabase.dbo.Complaints C on...

Yes, I mentioned that running the exact code in a SQL...

Thanks for the replies. I know the SP is hitting the correct database, because it completes 1 of the inserts correctly, but just "stops" at the next one.

All I can...

I tried it, no improvement

Do you think that would make a difference in my case ?

All our similar SP code uses VARCHAR.

In case it helps, here the whole SP, with a comment where @SQL_CMD WORKS and @SQL_CMD DOES NOT WORK.

Must be some dumb mistake somewhere.

ALTER procedure dbo.usp_JobMatch_ListTransfer

@Job_ID int...

What's the best way to trap for possible error on the dynamic INSERT statement ?

An earlier dynamic INSERT to a different table in the same database does work, so it's...

All the "@SQL_CMD" are INSERT statements.

The process is for a simple utility for users. They enter some parameters such as Job#, State, and search string. The Stored Procedure does...

Is there an index on date ?

The stored procedure takes input parameters from a user,

truncates a work table,

runs 3-4 queries to re-populate the work table.

Then I want to select 3 columns of data from that...

I believe I have the state code worked out. Thanks for all the help.

Now working on the lack of results.

The records selected in the stored procedure's SELECT JOB, STATE...

Smendle (6/27/2016)

---

homebrew01 (6/27/2016)

---

BUT ....... Now RS seems to handle the parameters in a select list differently if there's 1 chosen or multiples.

If I select just sate CA, I get...

BUT ....... Now RS seems to handle the parameters in a select list differently if there's 1 chosen or multiples.

If I select just sate CA, I get good results...