Tested 'Yay!' with not exists and it works just as good as 1.

I'll be the first to admit that I'm not a SQL master, so I don't know if there...

In this case (and correct me if I'm wrong), because you are checking if something doesn't exists, 1 is like true. You don't need to return *, you just want...

Thats awesome. Somehow I had forgotten about cross joins. If you don't use it you lose it I guess.

So yeah, that'll work perfectly. Thanks a ton

What if you wanted to send stuff to multiple tables?

<recallitem>

<RecallNum></RecallNum>

<Description></Description>

<Expires></Expires>

<DealerTypeID>1</DealerTypeID>

<Items>

<RecallItems>

<Correction></Correction>

<LaborOp></LaborOp>

<Labor></Labor>

</RecallItems>

<RecallItems>

<Correction></Correction>

<LaborOp></LaborOp>

<Labor></Labor>

</RecallItems>

<RecallItems>

<Correction></Correction>

<LaborOp></LaborOp>

<Labor></Labor>

</RecallItems>

</Items>

<RecallExplain>

<Explaination></Explaination>

</RecallExplain>

</recallitem>

Where you can have multiple recallitems and recallexplain tags. My solution was to write something in vb.net to loop through these...