This forum is Microsoft SQL Server.

here is some code that may give some ideas...remember this code is for Microsoft SQL Server

USE [tempdb]

GO

CREATE TABLE [dbo].[MSA]

(

[id] [int] NULL,

[u_id] [int] NULL,

[shost_name] [varchar](128) NULL,

[time_stamp] [bigint] NULL

)

GO

INSERT INTO MSA ( id,u_id,shost_name,time_stamp)

SELECT '1','3',' 172.24.1.143','1363038356' UNION ALL

SELECT '873','4',' 157.191.122.36','1369773601' UNION ALL

SELECT '883','83',' 157.191.122.36','1369774959' UNION ALL

SELECT '893','83',' 157.191.122.36','1369818602' UNION ALL

SELECT '903','83',' 157.191.122.36','1369838690' UNION ALL

SELECT '913','83',' 157.191.122.36','1369840224' UNION ALL

SELECT '923','83',' 157.191.122.36','1369841748' UNION ALL

SELECT '933','83',' 157.191.122.36','1370255417' UNION ALL

SELECT '943','83',' 157.191.122.36','1370258059' UNION ALL

SELECT '953','83',' 157.191.122.36','1370258060' UNION ALL

SELECT '963','93',' 157.191.122.36','1370299827' UNION ALL

SELECT '973','93',' 157.191.122.36','1370299852' UNION ALL

SELECT '983','93',' 157.191.122.36','1370299899' UNION ALL

SELECT '993','93',' 157.191.122.36','1370299920' UNION ALL

SELECT '1003','93',' 157.191.122.36','1370299995' UNION ALL

SELECT '1013','93',' 157.191.122.36','1370319811' UNION ALL

SELECT '1023','3',' 157.191.122.36','1370319835' UNION ALL

SELECT '1033','93',' 157.191.122.36','1370319939' UNION ALL

SELECT '1043','83',' 157.191.122.36','1370320312' UNION ALL

SELECT '1053','93',' 157.191.122.36','1370320640' UNION ALL

SELECT '1063','3',' 157.191.122.36','1370320713' UNION ALL

SELECT '1073','83',' 157.191.122.36','1370363702' UNION ALL

SELECT '1083','83',' 157.191.122.36','1370363987' UNION ALL

SELECT '1093','3',' 157.191.122.36','1370364021' UNION ALL

SELECT '1103','3',' 157.191.122.36','1370364028' UNION ALL

SELECT '1113','83',' 157.191.122.36','1370365896' UNION ALL

SELECT '1123','93',' 157.191.122.36','1370366087' UNION ALL

SELECT '1133','93',' 157.191.122.36','1370367070' UNION ALL

SELECT '1143','3',' 157.191.122.36','1370368567' UNION ALL

SELECT '1153','3',' 157.191.122.36','1370368575' UNION ALL

SELECT '1163','83',' 157.191.122.36','1370379345' UNION ALL

SELECT '1173','83',' 157.191.122.36','1370427302' UNION ALL

SELECT '1183','83',' 157.191.122.36','1370503422' UNION ALL

SELECT '1193','93',' 157.191.122.36','1370534329' UNION ALL

SELECT '1203','83',' 157.191.122.36','1370866207' UNION ALL

SELECT '1213','83',' 157.191.122.36','1370871353' UNION ALL

SELECT '1223','83',' 157.191.122.36','1370877702' UNION ALL

SELECT '1233','83',' 157.191.122.36','1371015245' UNION ALL

SELECT '1243','83',' 157.191.122.36','1371069245' UNION ALL

SELECT '1253','83',' 157.191.122.36','1371117509' UNION ALL

SELECT '1263','83',' 157.191.122.36','1371137716' UNION ALL

SELECT '1273','83',' 157.191.122.36','1371197327' UNION ALL

SELECT '1283','83',' 157.191.122.36','1371427531' UNION ALL

SELECT '1293','83',' 157.191.122.36','1371552899' UNION ALL

SELECT '1303','83',' 157.191.122.36','1371635304' UNION ALL

SELECT '1313','93',' 157.191.122.36','1371770752' UNION ALL

SELECT '1323','93',' 157.191.122.36','1371771394' UNION ALL

SELECT '1333','3',' 157.191.122.36','1371771647' UNION ALL

SELECT '1343','3',' 157.191.122.36','1371772611' UNION ALL

SELECT '1353','3',' 157.191.122.36','1371772626'

--=== following may get you started

SELECT u_id, shost_name, COUNT(DISTINCT time_stamp) AS visits

FROM MSA

GROUP BY u_id, shost_name

ORDER BY u_id, shost_name