Viewing 15 posts - 2,101 through 2,115 (of 4,820 total)
October 5, 2017 at 7:09 am
declare @name varchar(10) = 'Server';
SELECT TOP (LEN(@name)) SUBSTRING(@name, ROW_NUMBER() OVER(ORDER BY (SELECT NULL)), 1)
FROM sys.all_objects;
This will do the job, but the question is, do you...
October 5, 2017 at 7:05 am
October 5, 2017 at 6:34 am
October 5, 2017 at 6:24 am
October 5, 2017 at 6:18 am
Figuring I might as well post the @@VERSION value for the server I'm working on:
Microsoft SQL Server 2014 (SP2-CU7) (KB4032541) - 12.0.5556.0 (X64)
Aug 17 2017 12:07:38...
October 4, 2017 at 12:30 pm
Interesting. What exact T-SQL is producing this result? I just tried select on sysdatetime(), and never repeated the last 3 or 4 digits, and then I tried converting it to...
October 4, 2017 at 12:10 pm
Please note that your existing query was actually counting SEPTEMBER as well as you went back 2 months from the 1st of October, which is August 1st, and then spanned...
October 4, 2017 at 12:00 pm
Try this out:SELECT '1) Total non-employees terminated' AS [DESCRIPTION],
SUM(CASE MONTH(update_on) WHEN 8 THEN 1 ELSE 0 END) AS AUGUST,
SUM(CASE MONTH(update_on) WHEN 9 THEN 1 ELSE 0 END) AS...
October 4, 2017 at 11:57 am
October 4, 2017 at 11:13 am
I'm pretty sure that's not possible, at least within SSRS anyway. The only way you could achieve that I can think of, would be via a web page with a...
October 4, 2017 at 11:06 am
Excellent demonstration of the FACTS, Jeff !!! It's a shame more people don't have some basic math education on this stuff.
October 4, 2017 at 10:46 am
Viewing 15 posts - 2,101 through 2,115 (of 4,820 total)