Viewing 15 posts - 1 through 15 (of 2,468 total)
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
September 10, 2014 at 8:48 am
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...
September 10, 2014 at 8:15 am
hakim.ali (8/6/2012)
sushila (8/6/2012)
No one deliberately writes mediocre code
Yes, we all write code to the best of our ability. But the best of our ability does not always mean the best....
August 6, 2012 at 9:37 am
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...
August 6, 2012 at 8:31 am
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...
February 13, 2012 at 7:33 am
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...
December 1, 2011 at 5:47 am
Ah the good old day, when techers didn't know about copy / paste :-D.
Tsk tsk Remi - in a hurry to type eh - it's good old days (plural) and...
September 14, 2011 at 8:06 am
Look who's back from the dead...
welcome home.
😀 I don't want to detract from the focus of this forum - but I'm not really home yet - was just stopping by...
September 14, 2011 at 5:25 am
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...
September 14, 2011 at 5:00 am
"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...
June 30, 2011 at 3:39 am
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...
June 22, 2011 at 8:15 am
gonickl (4/2/2009)
June 13, 2011 at 5:23 am
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.
February 18, 2011 at 4:30 am
SuperDBA-207096 (10/7/2009)
Andy - I would agree.Only thing that bothers me is when people use meaningless abbreviations like
select a.somefield, b.somefield
from table1 a, table2data b
A and B are not too informative....
Hence Jeff's...
October 7, 2009 at 10:33 am
"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...
October 7, 2009 at 9:49 am
Viewing 15 posts - 1 through 15 (of 2,468 total)