Viewing 15 posts - 2,356 through 2,370 (of 8,753 total)
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
If @action='Save' or @action='Submit' then the procedure will add the data to the SSMC_EPMT.dbo.EPMT_TBL_REQUEST table
😎
Suggest you generate some sample data in order to make your ,net code work,...
February 6, 2017 at 2:07 am
Out of curiosity, why duplicate the results?
😎
You could do something like thisDECLARE @x XML = '<revieves>
<recievemessages>
<message>test</message>
<to>111111</to>
February 6, 2017 at 12:45 am
Viewing 15 posts - 2,356 through 2,370 (of 8,753 total)