When I click the 'parameters' button, I get this error:
The column prefix 'pw' does not match with a table name or
alias name used in the query.
The column prefix 'x' does not match with a table name or
alias name used in the query.

Replacing the "?"s with hardcoded values works fine.

Here is the SQL Statement:
update roster_run_xref
set incl_sunday_ind = 1
from roster_run_xref x
inner join roster ro
on ro.roster_id = x.roster_id
and ro.time_table_version_id = x.time_table_version_id
inner join run r
on r.run_id = x.run_id
and r.time_table_version_id = x.time_table_version_id
inner join operator o
on o.operator_id = ro.signup_operator_id
inner join ltd_midas_operators_picked_work_per_bid pw
on pw.badge = o.badge
and pw.runnum = r.run_designator
where x.time_table_version_id = ?
and pw.pickid = ?
and pw.sun_run = 1

Can you try changing the statement to start

UPDATE X
SET.........................

same reason as this does not work

update authors
SET authors.au_id = authors.au_id
from authors a JOIN titleauthor ta on a.au_id = ta.au_id

and this does


update a
SET a.au_id = a.au_id
from authors a JOIN titleauthor ta on a.au_id = ta.au_id



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Larry Storm" <larry.storm (AT) ltd (DOT) org> wrote