Viewing 15 posts - 2,551 through 2,565 (of 5,111 total)
Try:ALTER TABLE #test_table ADD [Page] AS CONVERT(int,((CP - 1) / 10) + 1);
In regards to the date format, it's best to do that in your presentation layer, rather...
November 18, 2017 at 11:06 am
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
November 18, 2017 at 11:00 am
select *
from #test_table
where [Date] >='2016-12-01' and [Date] <'2017-02-10'
How...
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...
November 18, 2017 at 10:26 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...
November 17, 2017 at 10:58 am
November 17, 2017 at 10:05 am
The CEO does it every Friday after lunch. Usually there's a 3-4...
November 17, 2017 at 8:48 am
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...
November 17, 2017 at 6:00 am
November 17, 2017 at 5:56 am
Question, are you really on SQL Server 2008? This would be far simpler on 2012 onwards.
November 17, 2017 at 5:53 am
I have set my Run64BitRuntime November 17, 2017 at 4:40 am
Viewing 15 posts - 2,551 through 2,565 (of 5,111 total)