Convert your date to datetime data type first - CAST(LAST_MOD_DT AS Date)

Use this link for knowledge reference: http://sqlmag.com/sql-server/solving-datetime-mystery

If I understand your requirement correctly, you would need something like this:

;With ID_TotalCount(Int_ID, Int_IDTotalCount)

AS

(

SELECTInt_ID, COUNT(Int_ID)

FROMdbo.tblData

GROUP BYInt_ID

),

ID_OpenCount(Int_ID, Int_IDOpenCount)

AS

(

SELECTInt_ID, COUNT(Int_ID)

FROMdbo.tblData

WHEREEvent = 'Open'

GROUP BYInt_ID

)

SELECTDISTINCT td.Int_ID

,ISNULL(Int_IDOpenCount, 0) AS Opened

,ISNULL(Int_IDTotalCount - Int_IDOpenCount, -1) AS Diff...

hakim.ali (8/6/2012)

---

Yes, we all write code to the best of our ability. But the best of our ability does not always mean the best....

When developers are coding, most are doing what they think is their best. No one deliberately writes mediocre code, so reviewers need the tact and diplomacy of ambassadors. Few people...

Something that uses "multiple columns", "multiple conditions" in any abbreviated form/combination that you may find makes sense in your environment?! :unsure:

I would tend to stick as closely as possible to...

Thank you David - for opening up a whole new world! I'm not sure why isn't this a global norm - both the concept as well as the (now seemingly...

Tsk tsk Remi - in a hurry to type eh - it's good old days (plural) and...

😀 I don't want to detract from the focus of this forum - but I'm not really home yet - was just stopping by...

CONGRATULATIONS Jeff!!! I cannot think of anyone who deserves it more. You've always been exceptional - glad that the recognition has been formalised.

I'm hoping that Steve posts clips...

"After all, companies lie in interviews almost as much as candidates"!

How very true and sad that is! In retrospect I feel I was very naive and gullible when I started...

I found this link but it's only for updating intellisense - http://lukehayler.com/2011/03/refresh-intellisense-in-sql-server-management-studio-2008/ (I, however, do not have this under my Edit menu)

no hotkeys to enable/disable - but honestly - if...

gonickl (4/2/2009)

---

Yes, you're probably right, Carolyn. I can see how it looks that way. Sorry. The way this happened was that I had a different cartoon in mind about male...

If you mean you don't want to set it via "Tools-options-Text Editor-TSql-Intellisense', you can always add the SQL Editor toolbar (using Tools-customize) and enable/disable without any navigation.

Hence Jeff's...

"Boy. You really have a low opinion of our field. Do your employees feel the same way? How depressing! Maybe you feel that way but programs I wrote 30 yrs...