QUERY HELP: Selecting distinct for two columns group by one

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • KoliPoki
    #1

    QUERY HELP: Selecting distinct for two columns group by one

    Greetings.

    I'm having a little trouble with a query. The idea is simple I need to
    display a list of recently unique visited URLs and the last time I
    visited.

    I have 2 table one stores the user and time/date and another has the
    URL.

    So all I need is the URL (no duplicates) and the last visit.

    Below is the SQL to create the tables and data to help with the query.

    Thank you for your help.


    CREATE TABLE [stat_hits] (
    [hit_id] [int] (1, 1) NOT NULL ,
    [hit_date] [datetime] NOT NULL CONSTRAINT [DF_stat_hits_hi t_date]
    DEFAULT (getdate()),
    [user_id] [varchar] (12) NOT NULL ,
    [hit_ip] [varchar] (15) NOT NULL ,
    [shp_id] [int] NOT NULL ,
    CONSTRAINT [PK_stat_hits] PRIMARY KEY CLUSTERED
    (
    [hit_id]
    ) ON [PRIMARY]
    ) ON [PRIMARY]
    GO


    CREATE TABLE [stat_hit_pages] (
    [shp_id] [int] (1, 1) NOT NULL ,
    [shp_url] [varchar] (1000) NULL ,
    [shp_count] [int] NULL ,
    CONSTRAINT [PK_stat_hit_pag es] PRIMARY KEY CLUSTERED
    (
    [shp_id]
    ) ON [PRIMARY]
    ) ON [PRIMARY]
    GO


    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37878,'2005-06-01 16:07:35','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37877,'2005-06-01 16:07:13','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37876,'2005-06-01 15:41:17','ADMI N','0.0.0.0',73 39)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37875,'2005-06-01 15:41:03','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37874,'2005-06-01 15:20:31','ADMI N','0.0.0.0',73 30)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37873,'2005-06-01 15:20:28','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37872,'2005-06-01 14:45:46','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37871,'2005-06-01 14:35:51','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37870,'2005-06-01 14:30:25','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37869,'2005-06-01 14:28:28','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37868,'2005-06-01 14:28:23','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37867,'2005-06-01 14:28:17','ADMI N','0.0.0.0',73 22)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37866,'2005-06-01 14:28:15','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37861,'2005-06-01 14:27:09','ADMI N','0.0.0.0',73 39)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37860,'2005-06-01 14:27:05','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37859,'2005-06-01 14:26:59','ADMI N','0.0.0.0',73 22)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37858,'2005-06-01 14:26:58','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37853,'2005-06-01 14:25:59','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37852,'2005-06-01 14:23:51','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37851,'2005-06-01 13:58:49','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37850,'2005-06-01 13:44:06','ADMI N','0.0.0.0',73 30)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37849,'2005-06-01 13:44:04','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37848,'2005-06-01 13:44:04','ADMI N','0.0.0.0',73 40)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37847,'2005-06-01 13:43:58','ADMI N','0.0.0.0',73 30)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37846,'2005-06-01 13:43:53','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37845,'2005-06-01 13:26:29','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37844,'2005-06-01 13:22:34','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37843,'2005-06-01 13:22:29','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37842,'2005-06-01 13:21:15','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37841,'2005-06-01 13:19:17','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37840,'2005-06-01 13:17:20','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37839,'2005-06-01 13:17:20','ADMI N','0.0.0.0',73 20)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37838,'2005-06-01 11:55:15','ADMI N','0.0.0.0',73 39)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37837,'2005-06-01 11:55:09','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37836,'2005-06-01 11:53:08','ADMI N','0.0.0.0',73 38)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37835,'2005-06-01 11:53:01','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37834,'2005-06-01 11:34:34','ADMI N','0.0.0.0',73 37)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37833,'2005-06-01 11:34:24','ADMI N','0.0.0.0',73 36)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37832,'2005-06-01 11:02:59','ADMI N','0.0.0.0',73 35)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37831,'2005-06-01 11:02:53','ADMI N','0.0.0.0',73 34)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37830,'2005-06-01 11:02:46','ADMI N','0.0.0.0',73 24)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37829,'2005-06-01 11:02:40','ADMI N','0.0.0.0',73 33)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37828,'2005-06-01 11:02:31','ADMI N','0.0.0.0',73 32)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37827,'2005-06-01 11:02:25','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37826,'2005-06-01 11:02:21','ADMI N','0.0.0.0',73 31)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37825,'2005-06-01 11:02:12','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37824,'2005-06-01 11:01:23','ADMI N','0.0.0.0',73 30)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37823,'2005-06-01 11:01:21','ADMI N','0.0.0.0',73 28)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37822,'2005-06-01 11:01:20','ADMI N','0.0.0.0',73 27)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37821,'2005-06-01 10:58:23','ADMI N','0.0.0.0',73 30)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37820,'2005-06-01 10:58:10','ADMI N','0.0.0.0',73 28)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37819,'2005-06-01 10:58:09','ADMI N','0.0.0.0',73 27)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37818,'2005-06-01 10:55:27','ADMI N','0.0.0.0',73 26)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37817,'2005-06-01 10:55:23','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37816,'2005-06-01 10:55:17','ADMI N','0.0.0.0',73 22)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37815,'2005-06-01 10:55:16','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37810,'2005-06-01 10:54:20','ADMI N','0.0.0.0',73 30)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37809,'2005-06-01 10:54:12','ADMI N','0.0.0.0',73 29)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37808,'2005-06-01 10:51:30','ADMI N','0.0.0.0',73 28)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37807,'2005-06-01 10:51:29','ADMI N','0.0.0.0',73 27)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37806,'2005-06-01 10:51:10','ADMI N','0.0.0.0',73 28)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37805,'2005-06-01 10:51:09','ADMI N','0.0.0.0',73 27)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37804,'2005-06-01 10:35:46','ADMI N','0.0.0.0',73 26)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37803,'2005-06-01 10:35:41','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37802,'2005-06-01 10:35:29','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37801,'2005-06-01 10:35:21','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37800,'2005-06-01 10:35:20','ADMI N','0.0.0.0',73 20)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37799,'2005-06-01 10:33:58','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37798,'2005-06-01 10:33:50','ADMI N','0.0.0.0',73 28)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37797,'2005-06-01 10:33:50','ADMI N','0.0.0.0',73 27)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37796,'2005-06-01 10:33:09','ADMI N','0.0.0.0',73 26)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37795,'2005-06-01 10:33:05','ADMI N','0.0.0.0',73 25)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37794,'2005-06-01 10:32:45','ADMI N','0.0.0.0',73 24)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37793,'2005-06-01 10:32:18','ADMI N','0.0.0.0',73 23)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37792,'2005-06-01 10:31:47','ADMI N','0.0.0.0',73 22)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37791,'2005-06-01 10:31:31','ADMI N','0.0.0.0',73 21)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37790,'2005-06-01 10:31:31','ADMI N','0.0.0.0',73 20)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37789,'2005-06-01 10:30:04','ADMI N','0.0.0.0',73 20)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37788,'2005-05-31 20:49:56','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37787,'2005-05-31 20:49:54','ADMI N','0.0.0.0',59 42)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37786,'2005-05-31 20:49:54','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37785,'2005-05-31 20:49:02','ADMI N','0.0.0.0',59 42)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37784,'2005-05-31 20:48:54','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37783,'2005-05-31 20:48:53','ADMI N','0.0.0.0',59 42)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37782,'2005-05-31 20:48:52','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37781,'2005-05-31 20:48:41','ADMI N','0.0.0.0',59 41)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37780,'2005-05-31 20:48:37','ADMI N','0.0.0.0',21 5)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37779,'2005-05-31 20:48:30','ADMI N','0.0.0.0',4)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37775,'2005-05-31 20:46:44','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37774,'2005-05-31 20:46:40','ADMI N','0.0.0.0',73 19)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37773,'2005-05-31 20:46:39','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37772,'2005-05-31 20:46:12','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37771,'2005-05-31 20:46:09','ADMI N','0.0.0.0',73 19)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37770,'2005-05-31 20:46:08','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37769,'2005-05-31 20:45:55','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37768,'2005-05-31 20:45:52','ADMI N','0.0.0.0',73 19)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37767,'2005-05-31 20:45:51','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37766,'2005-05-31 20:45:33','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37765,'2005-05-31 20:45:29','ADMI N','0.0.0.0',73 19)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37764,'2005-05-31 20:45:29','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37763,'2005-05-31 20:45:28','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37762,'2005-05-31 20:44:52','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37761,'2005-05-31 20:44:48','ADMI N','0.0.0.0',73 19)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37760,'2005-05-31 20:44:47','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37759,'2005-05-31 20:44:23','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37758,'2005-05-31 20:44:18','ADMI N','0.0.0.0',73 19)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37757,'2005-05-31 20:44:18','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37756,'2005-05-31 20:43:50','ADMI N','0.0.0.0',62 58)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37755,'2005-05-31 20:43:41','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37754,'2005-05-31 20:43:37','ADMI N','0.0.0.0',73 18)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37753,'2005-05-31 20:43:36','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37752,'2005-05-31 20:43:31','ADMI N','0.0.0.0',73 17)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37751,'2005-05-31 20:43:16','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37750,'2005-05-31 20:43:10','ADMI N','0.0.0.0',66 84)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37749,'2005-05-31 20:43:10','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37748,'2005-05-31 20:40:04','ADMI N','0.0.0.0',73 18)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37747,'2005-05-31 20:40:00','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37746,'2005-05-31 20:39:52','ADMI N','0.0.0.0',73 17)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37745,'2005-05-31 20:39:24','ADMI N','0.0.0.0',73 16)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37744,'2005-05-31 20:39:23','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37743,'2005-05-31 20:35:56','ADMI N','0.0.0.0',73 15)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37742,'2005-05-31 20:35:43','ADMI N','0.0.0.0',73 11)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37741,'2005-05-31 20:34:17','ADMI N','0.0.0.0',73 14)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37740,'2005-05-31 20:34:17','ADMI N','0.0.0.0',14 49)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37739,'2005-05-31 20:34:01','ADMI N','0.0.0.0',73 13)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37738,'2005-05-31 20:33:54','ADMI N','0.0.0.0',73 12)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37737,'2005-05-31 20:12:57','ADMI N','0.0.0.0',66 81)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37736,'2005-05-31 20:09:40','ADMI N','0.0.0.0',66 81)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37735,'2005-05-31 20:09:33','ADMI N','0.0.0.0',62 58)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37734,'2005-05-31 20:09:03','ADMI N','0.0.0.0',66 81)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37733,'2005-05-31 20:08:49','ADMI N','0.0.0.0',72 89)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37732,'2005-05-31 20:08:44','ADMI N','0.0.0.0',62 54)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37731,'2005-05-31 20:08:42','ADMI N','0.0.0.0',34 43)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37730,'2005-05-31 20:08:40','ADMI N','0.0.0.0',72 82)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37729,'2005-05-31 20:08:32','ADMI N','0.0.0.0',59 83)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37728,'2005-05-31 20:08:24','ADMI N','0.0.0.0',69 60)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37727,'2005-05-31 20:08:22','ADMI N','0.0.0.0',59 18)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37726,'2005-05-31 20:08:18','ADMI N','0.0.0.0',25 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37725,'2005-05-31 20:08:15','ADMI N','0.0.0.0',57 40)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37724,'2005-05-31 20:08:11','ADMI N','0.0.0.0',4)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37723,'2005-05-31 20:08:09','ADMI N','0.0.0.0',3)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37720,'2005-05-31 20:08:03','ADMI N','0.0.0.0',4)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37617,'2005-05-31 18:51:08','ADMI N','0.0.0.0',72 90)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37615,'2005-05-31 18:51:00','ADMI N','0.0.0.0',72 89)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37598,'2005-05-31 18:48:08','ADMI N','0.0.0.0',72 82)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37597,'2005-05-31 18:48:04','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37596,'2005-05-31 18:48:03','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37595,'2005-05-31 18:47:21','ADMI N','0.0.0.0',72 82)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37594,'2005-05-31 18:47:12','ADMI N','0.0.0.0',69 60)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37593,'2005-05-31 18:47:09','ADMI N','0.0.0.0',59 18)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37592,'2005-05-31 18:47:02','ADMI N','0.0.0.0',57 40)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37590,'2005-05-31 18:46:59','ADMI N','0.0.0.0',65 87)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37583,'2005-05-31 18:46:40','ADMI N','0.0.0.0',9)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37582,'2005-05-31 18:46:31','ADMI N','0.0.0.0',16 91)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37580,'2005-05-31 18:46:18','ADMI N','0.0.0.0',9)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37576,'2005-05-31 18:46:04','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37575,'2005-05-31 18:46:02','ADMI N','0.0.0.0',59 42)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37574,'2005-05-31 18:46:01','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37569,'2005-05-31 18:45:24','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37568,'2005-05-31 18:45:16','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37567,'2005-05-31 18:45:16','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37563,'2005-05-31 18:44:07','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37562,'2005-05-31 18:44:05','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37561,'2005-05-31 18:44:04','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37545,'2005-05-31 18:40:30','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37544,'2005-05-31 18:40:30','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37543,'2005-05-31 18:40:12','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37536,'2005-05-31 18:34:19','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37535,'2005-05-31 18:34:15','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37534,'2005-05-31 18:34:14','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37532,'2005-05-31 18:27:02','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37531,'2005-05-31 18:27:00','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37530,'2005-05-31 18:27:00','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37518,'2005-05-31 18:00:34','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37517,'2005-05-31 18:00:31','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37516,'2005-05-31 18:00:31','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37515,'2005-05-31 17:59:41','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37514,'2005-05-31 17:59:37','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37513,'2005-05-31 17:59:37','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37512,'2005-05-31 17:59:01','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37511,'2005-05-31 17:58:58','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37510,'2005-05-31 17:58:57','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37509,'2005-05-31 17:56:16','ADMI N','0.0.0.0',66 10)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37508,'2005-05-31 17:56:07','ADMI N','0.0.0.0',69 89)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37507,'2005-05-31 17:56:01','ADMI N','0.0.0.0',66 10)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37506,'2005-05-31 17:55:56','ADMI N','0.0.0.0',72 71)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37505,'2005-05-31 17:55:52','ADMI N','0.0.0.0',71 99)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37504,'2005-05-31 17:55:43','ADMI N','0.0.0.0',72 71)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37503,'2005-05-31 17:55:41','ADMI N','0.0.0.0',71 99)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37502,'2005-05-31 17:53:57','ADMI N','0.0.0.0',72 69)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37501,'2005-05-31 17:53:44','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37500,'2005-05-31 17:53:40','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37499,'2005-05-31 17:53:40','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37498,'2005-05-31 17:52:18','ADMI N','0.0.0.0',72 69)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37497,'2005-05-31 17:52:06','ADMI N','0.0.0.0',72 71)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37496,'2005-05-31 17:51:28','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37495,'2005-05-31 17:51:22','ADMI N','0.0.0.0',61 03)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37494,'2005-05-31 17:51:22','ADMI N','0.0.0.0',31 )
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37493,'2005-05-31 17:51:01','ADMI N','0.0.0.0',69 79)
    INSERT INTO [stat_hits]
    ([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
    (37492,'2005-05-31 17:50:57','ADMI N','0.0.0.0',61 03)


    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (3,'/scripts/iMenu.asp?_Ref= 450493&_XID=400 00000&ParentID= ',2245)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (4,'/scripts/objects/MyZBF.asp?_XID= 19999900&_Ref=4 50493&_Ref2=',2 917)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7329,'/scripts/objects/list.asp?_XID=7 0000005&_Ref=13 98186089&_reset =true&_table=20 02000&|MenuID=4 0000000',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7330,'/scripts/objects/edit.asp?_XID=7 0000005&_Ref=13 98186089&_table =2002000&_item= ADAMDOUG',5)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7331,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=13 98186089&_table =1002009&_item= 225000000',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7332,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=13 98186089&_table =1002009&_item= 215000000',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7333,'/scripts/objects/list.asp?_XID=7 0000028&_Ref=13 98186089&_table =1002009&',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7334,'/scripts/objects/list.asp?_XID=7 0000028&_Ref=13 98186089&_table =1001000&_paren turl=1',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7335,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=13 98186089&_table =1001000&_item= 1002009&_parent url=1',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7336,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=13 98186089&_table =1001054&_item= 1000006&_parent url=3',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7337,'/scripts/objects/edit.asp?_xid=7 0000028&_ref=13 98186089&_table =1001054&&_pare nturl=3',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7338,'/scripts/objects/navigator.asp?_ xid=70000030&_r ef=1398186089', 12)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7339,'/scripts/objects/navigator.asp?_ xid=70000028&_r ef=1398186089', 2)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7340,'/scripts/iKnow.asp?_ref= 1398186089&_dee p=http%3A//ZBFw2kdev01/scripts/objects/edit.asp%3F_XID %3D70000005%26_ Ref%3D139818608 9%26_table%3D20 02000%26_item%3 DADAMDOUG',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (9,'/scripts/objects/list.asp?_XID=7 0000052&_Ref=45 0493&_reset=tru e&_table=215000 001&|MenuID=400 00000',1532)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (25,'/scripts/objects/list.asp?_XID=7 0000028&_Ref=45 0493&_reset=tru e&_table=100200 9&|MenuID=40000 000',144)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (31,'/scripts/objects/save.asp?',3986 )
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (215,'/scripts/objects/list.asp?_XID=7 0000030&_Ref=45 0493&_reset=tru e&_table=300106 2&|MenuID=40000 000',138)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (1449,'/scripts/objects/mappings.asp?', 17)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (1691,'/scripts/objects/edit.asp?_XID=7 0000052&_Ref=45 0493&_table=215 000001&_item=11 ',26)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (3443,'/scripts/objects/list.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1000&_parenturl =2',16)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (5740,'/scripts/objects/consolemaster.a sp?_XID=8000000 3&_Ref=450493&_ reset=true&show all=false&page_ id=215000002&|M enuID=40000000' ,177)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (5918,'/scripts/objects/consolemaster.a sp?_XID=8000000 3&_Ref=450493&s howall=false&mo de=listitself&i tem=215000006&p age_id=21500000 2',15)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (5941,'/scripts/objects/edit.asp?_XID=7 0000030&_Ref=45 0493&_table=300 1062&_item=12', 9)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (5942,'/scripts/objects/edit.asp?_XID=7 0000030&_Ref=45 0493&_table=300 1062&_item=12&_ formtab=&proces s=&step=&elem=' ,62)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (5983,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 2009&_item=2250 00000',15)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6103,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1002&_parenturl =3&_item=215000 018&_formtab=&p rocess=&step=&e lem=',21)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6254,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1000&_item=2250 00001&_parentur l=2',4)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6258,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1000&_item=2250 00001&_parentur l=2&',4)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6587,'/scripts/objects/consolemaster.a sp?_XID=8000000 4&_Ref=450493&_ reset=true&show all=false&page_ id=215000003&|M enuID=40000000' ,81)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6610,'/scripts/objects/consolemaster.a sp?_XID=8000000 4&_Ref=450493&s howall=false&pa ge_id=215000003 ',88)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6681,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1054&_item=2250 00175&_parentur l=4',3)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6684,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1054&_parenturl =4&_item=225000 175&_formtab=&p rocess=&step=&e lem=',7)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6960,'/scripts/objects/edit.asp?_XID=8 0000003&_Ref=45 0493&_table=215 000001&_item=68 ',3)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6979,'/scripts/objects/edit.asp?_XID=7 0000052&_Ref=45 0493&_table=215 000001&_item=16 1&process=21500 0001&step=21500 0003&elem=21500 0018',25)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (6989,'/scripts/objects/consolemaster.a sp?_XID=8000000 4&_Ref=450493&s howall=false&mo de=drill&item=2 15000120&drill_ id=215000005&pa ge_id=215000003 &group=1&desc=B TFG',54)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7199,'/scripts/objects/consolemaster.a sp?_XID=8000000 4&_Ref=450493&s howall=false&pa ge_id=215000006 ',24)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7269,'/scripts/objects/consolemaster.a sp?_XID=8000000 4&_Ref=450493&s howall=false&pa ge_id=215000010 ',3)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7271,'/scripts/objects/consolemaster.a sp?_XID=8000000 4&_Ref=450493&s howall=false&mo de=listitself&i tem=215000200&p age_id=21500000 6&group=1&desc= Operations%20Ex ecutive',3)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7282,'/scripts/objects/edit.asp?_XID=8 0000003&_Ref=45 0493&_table=215 000001&_item=68 &process=215000 001&step=215000 003&elem=215000 018',2)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7289,'/scripts/objects/edit.asp?_xid=8 0000003&_ref=45 0493&_table=225 000001&_item=75 &_parenturl=1', 1)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7290,'/scripts/objects/edit.asp?_xid=8 0000003&_ref=45 0493&_table=215 000016&_item=86 &_parenturl=1', 0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7311,'/scripts/objects/edit.asp?_XID=8 0000003&_Ref=45 0493&_table=225 000001&_item=75 ',11)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7312,'/scripts/objects/showpopup.asp?_ XID=80000003&_R ef=450493&_tabl e=225000001&_it em=75&destable= 225000001&_mode =mappings&_seed =72528.66',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7313,'/scripts/objects/mappings.asp?_X ID=80000003&_Re f=450493&_table =225000001&_ite m=75&destable=2 25000001&_mode= mappings&_seed= 72528.66&_popup =true',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7314,'/scripts/objects/edit.asp?_XID=8 0000003&_Ref=45 0493&_table=225 000001&_item=90 &process=&step= &elem=',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7315,'/scripts/objects/edit.asp?_xid=8 0000003&_ref=45 0493&_table=225 000001&_item=90 ',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7316,'/scripts/objects/edit.asp?_xid=8 0000003&_ref=45 0493&_table=225 000001&_item=90 &_formtab=0&pro cess=&step=&ele m=',0)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7317,'/scripts/objects/edit.asp?_xid=8 0000003&_ref=45 0493&_table=215 000016&_item=86 ',1)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7318,'/scripts/objects/edit.asp?_xid=8 0000003&_ref=45 0493&_table=215 000016&_item=86 &_formtab=&proc ess=&step=&elem =',1)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7319,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=45 0493&_table=100 1000&_parenturl =2&_item=225000 001&_formtab=&p rocess=&step=&e lem=',5)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7320,'/scripts/iknow.asp?_Ref= 1398186089',6)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7321,'/scripts/iMenu.asp?_Ref= 1398186089&_XID =40000000&Paren tID=',10)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7322,'/scripts/objects/MyZBF.asp?_XID= 19999900&_Ref=1 398186089&_Ref2 =',9)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7323,'/scripts/objects/list.asp?_XID=7 0000028&_Ref=13 98186089&_reset =true&_table=10 02009&|MenuID=4 0000000',8)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7324,'/scripts/objects/edit.asp?_XID=7 0000028&_Ref=13 98186089&_table =1002009&_item= 1000001',1)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7325,'/scripts/objects/list.asp?_XID=7 0000030&_Ref=13 98186089&_reset =true&_table=30 01062&|MenuID=4 0000000',6)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7326,'/scripts/objects/edit.asp?_XID=7 0000030&_Ref=13 98186089&_table =3001062&_item= 12',2)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7327,'/scripts/objects/save.asp?',4)
    INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
    (7328,'/scripts/objects/edit.asp?_XID=7 0000030&_Ref=13 98186089&_table =3001062&_item= 12&_formtab=&pr ocess=&step=&el em=',4)

    Tags: None
    • Simon Hayes
      #2
      Re: QUERY HELP: Selecting distinct for two columns group by one

      Thanks for the DDL and data (although you need to check your syntax for
      the hit_id and shp_id columns - I guess you removed an IDENTITY
      defintion?). Assuming that you can join the tables on shp_id (there's
      no foreign key in your DDL), then this should do what you want:

      select
      shp.shp_url,
      max(sh.hit_date )
      from
      dbo.stat_hits sh
      join dbo.stat_hit_pa ges shp
      on sh.shp_id = shp.shp_id
      group by
      shp.shp_url

      Simon

        Comment

        • KoliPoki
          #3
          Re: QUERY HELP: Selecting distinct for two columns group by one

          Thanks simon.

          Spot on in everything u said, I feel silly now cos it was so obvious...
          I started creating derived tables.

          R.

            Comment

            Previous template Next
            Working...