Are you on freelancer.com?

If so, you can bid on the project I created fot this: http://www.freelancer.com/projects/1256329.html

you sir...are correct! Thanks so much, my client will be happy now, thanks to you 🙂

Ok, great! 🙂

And good luck with with moving.

Ok, Im back from my holiday and started testing it right away. This is what happens:

Ok, so I have this as my data:

DELETE FROM prospects

DELETE FROM prospectsincampaigns

declare @newid int

INSERT INTO...

That's quite alright, you've been a great help so far. 🙂

I will look into this after my holiday, so dont think I'm ignoring you ^^

Ok, I started that. Instead of doing it all on companyname I've now done it on companyphone, because you guys then have the same testdata I already posted earlier and...

Hi, ok, that works better.Now I tested it on a larger resultset, and there are companies that have NO name.

If a company has NO name I DONT want to delete...

You call that little issues? My respect to you sir, reminds me once again my life is actually pretty easy!

Ok, with the prospects and prospectsincampaigns tables, you can use the...

I ended up with this statement:

-- work out which non-min prospectsincampaigns rows should be deleted

select c.prospectid, c.campaignid into #deletions

from dbo.ProspectsInCampaigns c, dbo.prospects p

WHERE result = 0 and p.id = c.prospectid

and...

Ok, maybe Im not understanding you correctly, but in my last post I posted the 2 different options you gave me and the way I interpreted them.

So there are 2(!)...

I'm not sure what you mean there.

If you talk about the fact that I substituted campaignid=4 with campaignid=5, thats only because I was testing the code on another campaign....

Ok, hopefully you had a good night sleep, because Im back 🙂

This is where I start from:

START

idcompanyname

1355132Smeets M.B. Zuid-Limburg BV

1355133F.J. ten Berge BV

1355134F.J. ten Berge BV

1355135MacDonalds

1355136MacDonalds

1355137Duran BV

1355138Duran BV

1355139Duran BV

1355140Company in...

Ok I did that...that deletes the data from prospectsincampaigns for the specific campaign, good!

However *looks afraid to ask*, it still deletes all data from prospects that are NOT in the...

Which one? :$

I see 2 of them and I think I added the condition to both of them already...

Cool!! 😀

One more thing: Im now also trying to narrow it all down to a single campaign (4 in this case), so I added " and c.campaignid=4" on several lines,...