Home > IT Answers > Development > 0 Row affected
GPNel2006
75 pts.
0
Q:
0 Row affected
SQL, Update, Query, rows affected, Database engineering
Could you please assist with the following?

UPDATE dbo.[Elution_Report_Template]
SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM],
[Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

FROM dbo.[Elution_Report]
WHERE dbo.Elution_Report.ID = (SELECT max(ID) from dbo.Elution_Report ID)

It come back saing that 0 rows affected. Although there is data in the Elution_Report table.

Any Ideas?

Thank you
ASKED: Jun 29 2009  5:32 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Msi77
790 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You need join dbo.[Elution_Report_Template] with dbo.[Elution_Report]
Last Answered: Jun 29 2009  4:26 PM GMT by Msi77   790 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0