Viewing 15 posts - 2,356 through 2,370 (of 8,760 total)
poornima.s_pdi - Thursday, February 9, 2017 3:02 AMThanks Eirikur Eiriksson.
I got my result..
Really this forum is very helpful..Regards,
Poornima
You are very welcome.
😎
February 10, 2017 at 5:18 am
For fun, a variation of Chris's solution
😎
DECLARE @BINID VARBINARY(16) = NEWID();
;WITH BINARY_STUFF(DHASH,BINDATA,BINID)
AS
(
SELECT CONVERT(CHAR(64),HASHBYTES('SHA2_512',CONVERT(VARCHAR(36),@BINID,0)),2),CONVERT(VARCHAR(36),@BINID,0),@BINID UNION ALL
SELECT CONVERT(CHAR(64),HASHBYTES('SHA2_512',CONVERT(VARCHAR(36),@BINID,1)),2),CONVERT(VARCHAR(36),@BINID,1),@BINID UNION ALL
February 10, 2017 at 3:16 am
Simply remove the date from the group by clause
😎
SELECT
PD.ID
,PD.country
,COUNT(*) AS Login_frequency
FROM #promoter_details PD
INNER JOIN #login_info LI
ON PD.ID = LI.emp_id
GROUP BY...
February 9, 2017 at 2:48 am
Quick suggestion
😎
SELECT
PD.ID
,PD.country
,COUNT(*) AS Login_frequency
,CONVERT(DATE,LI.login_server_time,0) AS Login_Date
FROM #promoter_details PD
INNER JOIN #login_info LI
ON PD.ID = LI.emp_id
GROUP BY PD.ID
...
February 9, 2017 at 2:08 am
February 8, 2017 at 9:17 am
February 7, 2017 at 3:22 pm
February 7, 2017 at 12:22 pm
February 7, 2017 at 11:52 am
At home I use these from Harman Kardon, very good sound indeed
😎
February 7, 2017 at 9:59 am
February 7, 2017 at 9:01 am
February 6, 2017 at 9:53 am
Anyone...
February 6, 2017 at 9:41 am
February 6, 2017 at 2:12 am
Viewing 15 posts - 2,356 through 2,370 (of 8,760 total)