It's the "and a.cwsrouteid > b.cwsrouteid" clause that is eliminating CWSIDs 42, 47, 48.

CWSID 40 gets returned because of CWSRouteID 1.  Take out CWSRouteID 1 and you won't get any...

Good point, I spoke too soon.  Let me qualify my comment.  Neat trick if you need to do some data mining in a non-production situation....  Like you missed an AND...

That's pretty cool.

ok, here is a real dumb question I'm sure... but I've seen it enough and if I don't ask I will continue to be

Maybe you have some bad data.  Add WHERE IsDate(ContrExpirYDT) = 1 to remove any records with invalid date values.  Or do WHERE IsDate(ContrExpirYDT) = 0 to find records with invalid date...

select empname, emprole

from mytable

group by empname, emprole

having count(*) > 1

Ok, what do you expect the results to look like?  What do you expect for LogType when there is different logtypes for a particular ID?

select Table1.ID, Max(LogDate)

From Table1 join Table2 on Table1.ID = Table2.ID

Where LName like 'LN%'

Group by Table1.ID

Well, I think you have several options...

1. Don't use a trigger at all.    Instead, populate the audit table in the stored procedure that would...

The following statement, "SELECT @incidentID = inserted.IncidentID FROM inserted", will only keep the last record from inserted.  Therefore, the rest of the processing only works against that incident id.

You have...

Thanks for the input.

Any idea why the sql service memory usage keeps climbing in task manager?  I have max server memory set to 12 GB but it's currently at 14.9...

Chandu and Bapi, now that you fellas have the transaction log shrunk, you may want to start asking yourselves some more questions...

• Why was the log file so big in the...

Try to run "UPDATE STATISTICS [dbo].[CaseNum]

WITH FULLSCAN" manually.

Can you post the query as well as schema and row counts of any tables and views used?

First of all, I try to avoid bit columns altogether.  I am not sure why, but when working with 2000 I saw performance problems when querying bit columns across linked...