Viewing 15 posts - 2,551 through 2,565 (of 5,109 total)
Yes, but replace GETDATE() with your column. You also don't need the third parameter, unless you're converting to an (n)varchar. A date will always be returned in the format yyyy-MM-dd
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 18, 2017 at 11:00 am
select *
from #test_table
where [Date] >='2016-12-01' and [Date] <'2017-02-10'
How...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 18, 2017 at 10:36 am
VegasL - Saturday, November 18, 2017 9:50 AMHi Erik,Here's what I tried:
select *
from #test_table
where [Date] between '2016-12%' and '2017-02%'
Why are you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 18, 2017 at 10:26 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 11:06 am
It's also worth noting, however that the SUM of a "bunch" of NULL values is NULL, where as for COUNT the value would be 0. Similarly, the SUM of now...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 10:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 10:05 am
The CEO does it every Friday after lunch. Usually there's a 3-4...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 8:48 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 7:09 am
selpoivre - Friday, November 17, 2017 5:58 AMYou can answer query for 2012 .It would be great help
Thanks
But which environment are you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 6:00 am
Duplicate of https://www.sqlservercentral.com/Forums/1908328/Cumulative-subtraction.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 5:56 am
Question, are you really on SQL Server 2008? This would be far simpler on 2012 onwards.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 5:53 am
I have set my Run64BitRuntime Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 4:40 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2017 at 4:33 am
Viewing 15 posts - 2,551 through 2,565 (of 5,109 total)