Thanks steveb! I ended up manually editing the fields.

~Bhavna

I'm not. Tried with the " in the text qualifier box and it worked. Thanks Strick!

~Bhavna

Yes, I'll be splitting data based on the meeting code. I have about 100+ meeting codes. I'm still not sure how to use the conditional split. I have defined condition...

Thanks Tim!

Here is the query. I would like to generate seperate text file for each meeting

SELECT tblWrkshops.MeetingCode, SessionNumber= ISNULL(tblWrkshopSubjects.SessionNumb, '01'), tblSessionCons.ConsultantCode,

tblWrkshopSubjects.SubjectTitle, GenSubject = tbl_Subject_Code.parent_session_code--, tbl_lkp_ParentSessionCodes.ParentSessionTitle

FROM tblWrkshops LEFT JOIN...

Thanks Noel. I'm getting the correct results now.

Thank you!

I have to pull new changes in last one month. If there is a duplicate pull the last one. For e.g.

Join_Date...

That worked!

Thank you,

Bhavna

Thanks All!

I have changed the query to single quotes and that worked.

Thanks,

Bhavna

I have another question, I also have to update another field called mem_type in the same update statement. That field is not coming from table A. For mem_type I have to...

Thanks Jeff, it worked.

I have changed the temporary to global temp. tables and still getting the same error message.

Thanks brendthess, I am able to fix the problem everything works great.

I believe I have to use inner join for Event_date and that works. Now, if I use "OR" for the second loop in where clause, I get records that has...

Instead of going by ev.event_date is NULL, I am checking ev.event_date not between '4/01/2003' and '6/30/2003' still it does not work 🙁

Brendthess query sort of works, but still getting records that has event dates. Requirements for this query are: show all the records that have at least one clinical call, but...