Chris Morris-439714 (12/23/2009)

---

Back to basics...

-- 1. Write a query which returns the rows which you want updated from the table you want to update.

SELECT DISTINCT Confirmed, Attended, R.ParticipantID, NameFirst, NameLast,...

GilaMonster (12/23/2009)

---

Sorry, I misread a table name.

Seeing as some of the tables in the exists don't join together, I'd prefer to split it apart.

Which table are those datetime columns in?...

Unfortunately I did not design these tables, the Keys are not of any use on them.

In order to get to the to fields I need to update, I need...

All right that was a simple fix! Thanks Gila Monster. check it out here are the changes I made

CREATE PROCEDURE sp_DataTest

@fName as varchar(50),

@lName as varchar(50),

@pstrClass as varchar(50),

@strTranDateFrm as char(06),

@strTranDateTo as...