Forgot a semicolon :$ code works fine 🙂 thanks!

Ok, thanks both you guys. And what if I want to select this result into a temp table?

I now have (not working):

DECLARE @prosp TABLE (

id int

,companyname nvarchar(50)

,isincampaign bit

,cnt int

,incamp nvarchar(50)

)

with...

Ah, I didnt see all the code, my bad.

Anyway, your code seems to do [almost] what I need.

Currently your code shows: #duplicate records - 1, meaning that if I have...

@magoo: I think you were replying to an earlier post of me and not to my latest?

Ok, sorry, but I do have one more question.

I need to add a calculated column to the temp table: whether the selected records occur in another table 'prospectsincampaigns'.

I now have...

It does...thx!

thanks!

You're right, switched the 2 tables and now it does work 🙂

So, even maybe if you didnt fully mean to, it IS a copy paste solution 🙂

Thanks!

Both queries you provided dont seem to work 🙁

In table "prospects" the value of columns freedate1 and freeint1 are both NULL

In table "prospects_copy" the value of columns freedate1 is "2011-02-01...