You might want to use Microsoft SQLXML to bulkload the XML file into your SQL table. I have been using it and it has worked fine.

Thanks for the info andy. What I did was create new proc in my db called ups_makewebtask and just removed the sysadmin edit. I also added an edit to prevent...

No I just found the problem. Its yet another

“Undocumented feature” aka bug with SQLServer

7.0 🙁 You can't pass a variables to the Identity function seed value.

Greg

I would try this:

select T.TOUR_DATE, T.TOUR_STATUS_CODE

from d_tour T

left join p_contract_lead on

T.LEAD_ID = p_contract_lead.LEAD_ID

where T.TOUR_DATE between '03/01/02' and '04/30/02' and T.TOUR_STATUS_CODE = 2 and T.Office_Code in (34,37,40,43,55,65)

AND p_contract_lead.LEAD_ID...

Sorry posted my last reply in error.

I think this would work.

select a.*

from Figtree a

left join Vehicle b

on a.VehicleNo = b.Figtree_id

where b.Figtree_id is null

I try never...

Maybe this would work

SELECT *

FROM Figtree a

left join VehicleNo b.Figtree_id

Where b.Figtree_id is null

I want to find all entries in one table that are not in another.

The query...