khushbu.kumar (9/10/2008)

---

Thanks a lot Chris!

But the here posted code was just a snippet

i really dont know how many rows can be present(i'm selecting them on the basis of id...

Can you add dbo.tblCards.ID to SELECT to see if those records are actually duplicates?

If dbo.tblCards.ID will not repeat then they are not.

Joins don't add duplications.

Never.

It's either bad data or...

Why did you decide those 410 records are duplicates?

In your DISTINCT query you group by PrintDate, CardType.

So, if they have printed 10 cards of the same type on the same...

If to follow the logic of your query this is what you are trying to get:

SELECT a.strUserName, Count(A.ID) AS CardsPrinted

FROM dbo.tblUsers a

WHERE EXISTS(select 1

from dbo.tblEvents...

Try this:

USE MASTER

select * from syscolumns

where name like '%exec%'

See? Your filter would consider some system calls illegal.

Don't you have column "IsDeleted" anywhere in your database?

Many developers like those "flag" columns.

What...

icocks (9/5/2008)

---

A further thing to bear in mind - if there's an Insert trigger on the table, then it will be fired in response to option 2, but not option...

I always use IF EXISTS(select 1 from inserted) or deleted.

It allows not to run "insert" part of INSERT/UPDATE/DELETE trigger only when there are actually inserted rows.

Both options are identical on cost.

Both perform same SELECT and both perform INSERT only if SELECT returns no records.

The only important difference s that 2nd option escalates shared locks applied...

I'd like to see how.

I guess I'm not alone here.

Same question - how?

I agree with your POV but both solutions are efective to insert a new record without...

Can you prove it?

Open QA,...

Thanks guys for the feedback.

davidr (9/4/2008)

---

side note: we shouldn't really be doing "select *" to check for existence. If that's a LOONNNNGGGGG row there could be a...

Tomm,

THe beauty of the solution posted by Michael is it does not depend on DATEFIRST settings.

Moreover, it allows to set required "datefirst" as a parameter.

So, what's the point to...

You can add constraint at any time.

Just be aware - you live application will throw error when trying insert duplicates.

There is the query to identify rows to be deleted.

Once you see the candidates for deletion are correct - run commented DELETE.

SELECT T.*

--DELETE T

FROM tblprojectmembers T

INNER JOIN (

select count(*), MIN(ProjectMemberId)...

Sagar (9/2/2008)

---

projectmemberid- pk, projectid = fk not null, projectmemberuserid fk, null.

projectmemberuserid is equivalent to userid in another tbluser which has all the users. i know there is some...