how do I exclude it. I did not see that as an option anywhere?

Tried exporting but get the following errors:

Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "TIME_STAMP".

(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow Task: Column...

Gotta leave for today. I'll try this again tomorrow.

Thank you all for your time.

Not sure if this answers your question or not but I want the email addresses and ID for anyone on any committtee. the ID's are the link between the...

engintoksoz (12/9/2008)

---

I am not sure I understand correctly but I think having a subquery, to retrieve those records with the criteria first then apply your group by to find the...

IF OBJECT_ID('TempDB..#test','U') IS NOT NULL

DROP TABLE #test

CREATE TABLE #test

( ...

Yes I do get it now. Thank you. It'll be much easier for both sides next time!

OK i'm learning a lot just getting help. Which really is great.

I think I have what you need now.

SET IDENTITY_INSERT #test ON

--===== Insert the test data into...

Ok I'm fairly new at this but I'm trying.

Here is the data from the activity table.

SELECT 361708,000BIOT2, UNION ALL

SELECT 361865,000BIOT2, UNION ALL

SELECT 362184,000BIOT2, UNION ALL

SELECT 362215,000BIOT2, UNION ALL

SELECT 362261,000BIOT2,...

The column from the activity table I'm trying to pull, product_code will not display using the same query that I used for the name table. It is varchar but...

OK let's try this. Is this what you are looking for?

From name table:

SELECT '10002',Walton@email.chop.edu,'Vernathan Walton' UNION ALL

SELECT '10004',craig.engstrom@wfhc.org,'Craig W. Engstrom, CBET' UNION ALL

SELECT '10006',,'Larry R. Pallatt, CBET' UNION ALL

SELECT...

Sorry I read the link and I'm not fully understanding what I need to provide. There are two tables, the Activity table and the Name table. For an...

Thank you so much. This worked perfectly. Now to spend some time looking this over and learning it. You have been very helpfu.

I really appreciate all your help and patience with this.

What I need to do appears to be in two steps now.

1) Update the name_address table.

The name_address.email where...

Right sorry about that. The select statement is:

select preferred_mail, name.email, name_address.email,purpose from name,name_address

where name.id=name_address.id

and name.id='405691'

I accidentaly said the 'other' purpose instead of the 'home' purpose in my previous...