Congrats !

I found 462 to be the hardest of them all. I barely squeaked that one by. Measure Up was really, really good practice exams. Great explanations

Jeff,

As usually most excellent. I have no idea why doing a ITVF slipped by my feeble mind. Very, very elegant solution, works perfectly and is much cleaner and now I...

Thanks Eric, the reason I am using a table variable is so I can join the results. Ultimately I'm trying to end up with a adhoc table that I can...

WOW, That's why I love coming here so many great solutions for the same issue. I'm testing each one out but I think I may be replacing my loop with...

I'm closer I just need to figure out how to add the 1

DECLARE @Interval INT = 5

,@Span INT = 30

...

In Addition to all that great advice. Itzik Ben Gan's T-SQL fundamentals. It is a fantastic book. It helped me understand SQL beyond the syntax. When I...

Thank you sir that is exactly the info I was looking for!

Thank you all! Great suggestions. I will start researching each to find the best fit. 😀

Hi Steve,

Yes sir,

it is 2008 r2. I so wish for the day I can start coding using 2012. Unfortunately many of our customers are still lagging behind with 2008...

I have no idea if this will even work. If your training this many CTE's together there probably is a better way.

WITH Cnt AS (

select Count(Distinct UserID) as Entitled_Users, DATEFROMPARTS(YEAR(t.WhenAddedToGroup),MONTH(t.WhenAddedToGroup),1)...

Hi Danny,

It appears that you are mixing 3 queries with nothing in common at the bottom. You need some common element that they can join together on. If not they...

I got lost here

Select When_Added_To_Group, Entitled_Users, (Select SUM(t2.Entitled_Users) as Entitled_Users

from Cnt T2

where T2.When_Added_To_Group <=T1.When_Added_To_Group) as Running_Total,

Select Peak_concurrent_users, concurrent_date from Concurrent,

select SUM(Host_Capacity), Host_Boot_Time from Capacity

where When_Added_To_Group=Concurrent_date, When_Added_To_Group=Host_Boot_time

from Cnt T1

To me...

Here is with year and month

CREATE TABLE #Temp (When_Added_To_Sec_Group DATE , UserID INT)

INSERT #Temp Values ('10/2/2015',1), ('10/1/2015',2), ('11/24/2015',3),

('11/20/2015',4), ('11/18/2015',5), ('12/9/2015',6);

WITH Cnt AS(

SELECT COUNT(DISTINCT...

I think its 2008 so I don't think Datefromparts is kosher here.

danny.delgado 65386 (12/10/2015)

thanks for your quick reply, when I tried the query on my actual table there discrepancy on the Running Total....for example I queried the Total distinct UserID by...