Below is the SQL:
DECLARE @MyCounter int;
SET @MyCounter = 1;
IF EXISTS
(
SELECT *
FROM tempdb.dbo.sysobjects
WHERE ID = OBJECT_ID(N'tempdb..#LastLoginDetailsTempTable')
)
BEGIN
DROP TABLE #LastLoginDetailsTempTable
END
CREATE TABLE #LastLoginDetailsTempTable(
User_Not_Login_Day_Count int, Last_Login_User_Count int)
WHILE @MyCounter < 11
BEGIN
INSERT INTO #LastLoginDetailsTempTable(User_Not_Login_Day_Count, Last_Login_User_Count)
SELECT @MyCounter as User_Not_Login_Day_Count, COUNT(UserId) as Last_Login_User_Count
FROM LoginDetails AS T1
WHERE
(SELECT MIN(DATEDIFF(day,LastLoginDate, GETDATE()))
FROM LoginDetails AS T2
WHERE T2.UserID=T1.UserId) = @MyCounter
SET @MyCounter = @MyCounter + 1;
END
select * from #LastLoginDetailsTempTable