Thank you for the answer .. there isn't a little check box somewhere that says "Truncate"?

I have 270 fields to export ....

Jeff you are right that all the tables have matching records.

Indexes have been verified lots of times over.

The "parent" table has over a million records, and the two children each...

I like that !!! Thank you

I am interested as why you would say this in this case?

This is a one off query to extract information about some transactions that would be rarely used.

Thank you - worked like a charm.

That's awesome to know - thank you for your help!

http://www.mapbusinesssolutions.com

http://www.freesurveysonline.com

I was wondering, and I obviously need to do some tests but where you have:

SELECT @Return = CASE WHEN EXISTS (Select * from dbo.MyTable where id = @ID) THEN 1...

I was looking for just a procedure that returned whether or not a record or records existed for a particular ID.

That's it exactly! Beauty thanks!