QUERY HELP: Selecting Distinct For Two Columns Group By One

Jul 23, 2005

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_hit_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_pages] 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','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37877,'2005-06-01 16:07:13','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37876,'2005-06-01 15:41:17','ADMIN','0.0.0.0',7339)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37875,'2005-06-01 15:41:03','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37874,'2005-06-01 15:20:31','ADMIN','0.0.0.0',7330)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37873,'2005-06-01 15:20:28','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37872,'2005-06-01 14:45:46','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37871,'2005-06-01 14:35:51','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37870,'2005-06-01 14:30:25','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37869,'2005-06-01 14:28:28','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37868,'2005-06-01 14:28:23','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37867,'2005-06-01 14:28:17','ADMIN','0.0.0.0',7322)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37866,'2005-06-01 14:28:15','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37861,'2005-06-01 14:27:09','ADMIN','0.0.0.0',7339)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37860,'2005-06-01 14:27:05','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37859,'2005-06-01 14:26:59','ADMIN','0.0.0.0',7322)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37858,'2005-06-01 14:26:58','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37853,'2005-06-01 14:25:59','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37852,'2005-06-01 14:23:51','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37851,'2005-06-01 13:58:49','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37850,'2005-06-01 13:44:06','ADMIN','0.0.0.0',7330)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37849,'2005-06-01 13:44:04','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37848,'2005-06-01 13:44:04','ADMIN','0.0.0.0',7340)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37847,'2005-06-01 13:43:58','ADMIN','0.0.0.0',7330)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37846,'2005-06-01 13:43:53','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37845,'2005-06-01 13:26:29','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37844,'2005-06-01 13:22:34','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37843,'2005-06-01 13:22:29','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37842,'2005-06-01 13:21:15','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37841,'2005-06-01 13:19:17','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37840,'2005-06-01 13:17:20','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37839,'2005-06-01 13:17:20','ADMIN','0.0.0.0',7320)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37838,'2005-06-01 11:55:15','ADMIN','0.0.0.0',7339)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37837,'2005-06-01 11:55:09','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37836,'2005-06-01 11:53:08','ADMIN','0.0.0.0',7338)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37835,'2005-06-01 11:53:01','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37834,'2005-06-01 11:34:34','ADMIN','0.0.0.0',7337)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37833,'2005-06-01 11:34:24','ADMIN','0.0.0.0',7336)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37832,'2005-06-01 11:02:59','ADMIN','0.0.0.0',7335)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37831,'2005-06-01 11:02:53','ADMIN','0.0.0.0',7334)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37830,'2005-06-01 11:02:46','ADMIN','0.0.0.0',7324)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37829,'2005-06-01 11:02:40','ADMIN','0.0.0.0',7333)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37828,'2005-06-01 11:02:31','ADMIN','0.0.0.0',7332)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37827,'2005-06-01 11:02:25','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37826,'2005-06-01 11:02:21','ADMIN','0.0.0.0',7331)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37825,'2005-06-01 11:02:12','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37824,'2005-06-01 11:01:23','ADMIN','0.0.0.0',7330)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37823,'2005-06-01 11:01:21','ADMIN','0.0.0.0',7328)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37822,'2005-06-01 11:01:20','ADMIN','0.0.0.0',7327)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37821,'2005-06-01 10:58:23','ADMIN','0.0.0.0',7330)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37820,'2005-06-01 10:58:10','ADMIN','0.0.0.0',7328)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37819,'2005-06-01 10:58:09','ADMIN','0.0.0.0',7327)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37818,'2005-06-01 10:55:27','ADMIN','0.0.0.0',7326)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37817,'2005-06-01 10:55:23','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37816,'2005-06-01 10:55:17','ADMIN','0.0.0.0',7322)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37815,'2005-06-01 10:55:16','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37810,'2005-06-01 10:54:20','ADMIN','0.0.0.0',7330)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37809,'2005-06-01 10:54:12','ADMIN','0.0.0.0',7329)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37808,'2005-06-01 10:51:30','ADMIN','0.0.0.0',7328)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37807,'2005-06-01 10:51:29','ADMIN','0.0.0.0',7327)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37806,'2005-06-01 10:51:10','ADMIN','0.0.0.0',7328)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37805,'2005-06-01 10:51:09','ADMIN','0.0.0.0',7327)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37804,'2005-06-01 10:35:46','ADMIN','0.0.0.0',7326)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37803,'2005-06-01 10:35:41','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37802,'2005-06-01 10:35:29','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37801,'2005-06-01 10:35:21','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37800,'2005-06-01 10:35:20','ADMIN','0.0.0.0',7320)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37799,'2005-06-01 10:33:58','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37798,'2005-06-01 10:33:50','ADMIN','0.0.0.0',7328)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37797,'2005-06-01 10:33:50','ADMIN','0.0.0.0',7327)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37796,'2005-06-01 10:33:09','ADMIN','0.0.0.0',7326)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37795,'2005-06-01 10:33:05','ADMIN','0.0.0.0',7325)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37794,'2005-06-01 10:32:45','ADMIN','0.0.0.0',7324)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37793,'2005-06-01 10:32:18','ADMIN','0.0.0.0',7323)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37792,'2005-06-01 10:31:47','ADMIN','0.0.0.0',7322)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37791,'2005-06-01 10:31:31','ADMIN','0.0.0.0',7321)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37790,'2005-06-01 10:31:31','ADMIN','0.0.0.0',7320)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37789,'2005-06-01 10:30:04','ADMIN','0.0.0.0',7320)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37788,'2005-05-31 20:49:56','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37787,'2005-05-31 20:49:54','ADMIN','0.0.0.0',5942)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37786,'2005-05-31 20:49:54','ADMIN','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','ADMIN','0.0.0.0',5942)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37784,'2005-05-31 20:48:54','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37783,'2005-05-31 20:48:53','ADMIN','0.0.0.0',5942)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37782,'2005-05-31 20:48:52','ADMIN','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','ADMIN','0.0.0.0',5941)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37780,'2005-05-31 20:48:37','ADMIN','0.0.0.0',215)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37779,'2005-05-31 20:48:30','ADMIN','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','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37774,'2005-05-31 20:46:40','ADMIN','0.0.0.0',7319)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37773,'2005-05-31 20:46:39','ADMIN','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','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37771,'2005-05-31 20:46:09','ADMIN','0.0.0.0',7319)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37770,'2005-05-31 20:46:08','ADMIN','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','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37768,'2005-05-31 20:45:52','ADMIN','0.0.0.0',7319)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37767,'2005-05-31 20:45:51','ADMIN','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','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37765,'2005-05-31 20:45:29','ADMIN','0.0.0.0',7319)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37764,'2005-05-31 20:45:29','ADMIN','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','ADMIN','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','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37761,'2005-05-31 20:44:48','ADMIN','0.0.0.0',7319)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37760,'2005-05-31 20:44:47','ADMIN','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','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37758,'2005-05-31 20:44:18','ADMIN','0.0.0.0',7319)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37757,'2005-05-31 20:44:18','ADMIN','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','ADMIN','0.0.0.0',6258)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37755,'2005-05-31 20:43:41','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37754,'2005-05-31 20:43:37','ADMIN','0.0.0.0',7318)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37753,'2005-05-31 20:43:36','ADMIN','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','ADMIN','0.0.0.0',7317)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37751,'2005-05-31 20:43:16','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37750,'2005-05-31 20:43:10','ADMIN','0.0.0.0',6684)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37749,'2005-05-31 20:43:10','ADMIN','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','ADMIN','0.0.0.0',7318)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37747,'2005-05-31 20:40:00','ADMIN','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','ADMIN','0.0.0.0',7317)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37745,'2005-05-31 20:39:24','ADMIN','0.0.0.0',7316)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37744,'2005-05-31 20:39:23','ADMIN','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','ADMIN','0.0.0.0',7315)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37742,'2005-05-31 20:35:43','ADMIN','0.0.0.0',7311)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37741,'2005-05-31 20:34:17','ADMIN','0.0.0.0',7314)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37740,'2005-05-31 20:34:17','ADMIN','0.0.0.0',1449)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37739,'2005-05-31 20:34:01','ADMIN','0.0.0.0',7313)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37738,'2005-05-31 20:33:54','ADMIN','0.0.0.0',7312)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37737,'2005-05-31 20:12:57','ADMIN','0.0.0.0',6681)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37736,'2005-05-31 20:09:40','ADMIN','0.0.0.0',6681)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37735,'2005-05-31 20:09:33','ADMIN','0.0.0.0',6258)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37734,'2005-05-31 20:09:03','ADMIN','0.0.0.0',6681)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37733,'2005-05-31 20:08:49','ADMIN','0.0.0.0',7289)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37732,'2005-05-31 20:08:44','ADMIN','0.0.0.0',6254)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37731,'2005-05-31 20:08:42','ADMIN','0.0.0.0',3443)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37730,'2005-05-31 20:08:40','ADMIN','0.0.0.0',7282)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37729,'2005-05-31 20:08:32','ADMIN','0.0.0.0',5983)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37728,'2005-05-31 20:08:24','ADMIN','0.0.0.0',6960)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37727,'2005-05-31 20:08:22','ADMIN','0.0.0.0',5918)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37726,'2005-05-31 20:08:18','ADMIN','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','ADMIN','0.0.0.0',5740)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37724,'2005-05-31 20:08:11','ADMIN','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','ADMIN','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','ADMIN','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','ADMIN','0.0.0.0',7290)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37615,'2005-05-31 18:51:00','ADMIN','0.0.0.0',7289)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37598,'2005-05-31 18:48:08','ADMIN','0.0.0.0',7282)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37597,'2005-05-31 18:48:04','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37596,'2005-05-31 18:48:03','ADMIN','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','ADMIN','0.0.0.0',7282)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37594,'2005-05-31 18:47:12','ADMIN','0.0.0.0',6960)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37593,'2005-05-31 18:47:09','ADMIN','0.0.0.0',5918)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37592,'2005-05-31 18:47:02','ADMIN','0.0.0.0',5740)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37590,'2005-05-31 18:46:59','ADMIN','0.0.0.0',6587)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37583,'2005-05-31 18:46:40','ADMIN','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','ADMIN','0.0.0.0',1691)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37580,'2005-05-31 18:46:18','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37575,'2005-05-31 18:46:02','ADMIN','0.0.0.0',5942)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37574,'2005-05-31 18:46:01','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37568,'2005-05-31 18:45:16','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37567,'2005-05-31 18:45:16','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37562,'2005-05-31 18:44:05','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37561,'2005-05-31 18:44:04','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37544,'2005-05-31 18:40:30','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37543,'2005-05-31 18:40:12','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37535,'2005-05-31 18:34:15','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37534,'2005-05-31 18:34:14','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37531,'2005-05-31 18:27:00','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37530,'2005-05-31 18:27:00','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37517,'2005-05-31 18:00:31','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37516,'2005-05-31 18:00:31','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37514,'2005-05-31 17:59:37','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37513,'2005-05-31 17:59:37','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37511,'2005-05-31 17:58:58','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37510,'2005-05-31 17:58:57','ADMIN','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','ADMIN','0.0.0.0',6610)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37508,'2005-05-31 17:56:07','ADMIN','0.0.0.0',6989)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37507,'2005-05-31 17:56:01','ADMIN','0.0.0.0',6610)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37506,'2005-05-31 17:55:56','ADMIN','0.0.0.0',7271)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37505,'2005-05-31 17:55:52','ADMIN','0.0.0.0',7199)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37504,'2005-05-31 17:55:43','ADMIN','0.0.0.0',7271)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37503,'2005-05-31 17:55:41','ADMIN','0.0.0.0',7199)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37502,'2005-05-31 17:53:57','ADMIN','0.0.0.0',7269)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37501,'2005-05-31 17:53:44','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37500,'2005-05-31 17:53:40','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37499,'2005-05-31 17:53:40','ADMIN','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','ADMIN','0.0.0.0',7269)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37497,'2005-05-31 17:52:06','ADMIN','0.0.0.0',7271)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37496,'2005-05-31 17:51:28','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37495,'2005-05-31 17:51:22','ADMIN','0.0.0.0',6103)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37494,'2005-05-31 17:51:22','ADMIN','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','ADMIN','0.0.0.0',6979)
INSERT INTO [stat_hits]
([hit_id],[hit_date],[user_id],[hit_ip],[shp_id]) VALUES
(37492,'2005-05-31 17:50:57','ADMIN','0.0.0.0',6103)


INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(3,'/scripts/iMenu.asp?_Ref=450493&_XID=40000000&ParentID=',2245)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(4,'/scripts/objects/MyZBF.asp?_XID=19999900&_Ref=450493&_Ref2=',2917)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7329,'/scripts/objects/list.asp?_XID=70000005&_Ref=1398186089&_reset=true&_table=2002000&|MenuID=40000000',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7330,'/scripts/objects/edit.asp?_XID=70000005&_Ref=1398186089&_table=2002000&_item=ADAMDOUG',5)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7331,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1002009&_item=225000000',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7332,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1002009&_item=215000000',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7333,'/scripts/objects/list.asp?_XID=70000028&_Ref=1398186089&_table=1002009&',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7334,'/scripts/objects/list.asp?_XID=70000028&_Ref=1398186089&_table=1001000&_parenturl=1',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7335,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1001000&_item=1002009&_parenturl=1',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7336,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1001054&_item=1000006&_parenturl=3',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7337,'/scripts/objects/edit.asp?_xid=70000028&_ref=1398186089&_table=1001054&&_parenturl=3',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7338,'/scripts/objects/navigator.asp?_xid=70000030&_ref=1398186089',12)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7339,'/scripts/objects/navigator.asp?_xid=70000028&_ref=1398186089',2)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7340,'/scripts/iKnow.asp?_ref=1398186089&_deep=http%3A//ZBFw2kdev01/scripts/objects/edit.asp%3F_XID%3D70000005%26_Ref%3D1398186089%26_ table%3D2002000%26_item%3DADAMDOUG',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(9,'/scripts/objects/list.asp?_XID=70000052&_Ref=450493&_reset=true&_table=215000001&|MenuID=40000000',1532)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(25,'/scripts/objects/list.asp?_XID=70000028&_Ref=450493&_reset=true&_table=1002009&|MenuID=40000000',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=70000030&_Ref=450493&_reset=true&_table=3001062&|MenuID=40000000',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=70000052&_Ref=450493&_table=215000001&_item=11',26)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(3443,'/scripts/objects/list.asp?_XID=70000028&_Ref=450493&_table=1001000&_parenturl=2',16)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(5740,'/scripts/objects/consolemaster.asp?_XID=80000003&_Ref=450493&_reset=true&showall=false&page_id=215000002&|MenuID=40000000',177)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(5918,'/scripts/objects/consolemaster.asp?_XID=80000003&_Ref=450493&showall=false&mode=listitself&item=215000006&page_id=215000002',15)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(5941,'/scripts/objects/edit.asp?_XID=70000030&_Ref=450493&_table=3001062&_item=12',9)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(5942,'/scripts/objects/edit.asp?_XID=70000030&_Ref=450493&_table=3001062&_item=12&_formtab=&process=&step=&elem=',62)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(5983,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1002009&_item=225000000',15)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6103,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001002&_parenturl=3&_item=215000018&_formtab=&process=&step=&elem=',21)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6254,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001000&_item=225000001&_parenturl=2',4)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6258,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001000&_item=225000001&_parenturl=2&',4)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6587,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&_reset=true&showall=false&page_id=215000003&|MenuID=40000000',81)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6610,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&page_id=215000003',88)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6681,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001054&_item=225000175&_parenturl=4',3)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6684,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001054&_parenturl=4&_item=225000175&_formtab=&process=&step=&elem=',7)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6960,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=215000001&_item=68',3)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6979,'/scripts/objects/edit.asp?_XID=70000052&_Ref=450493&_table=215000001&_item=161&process=215000001&step=215000003&elem=215000018',25)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(6989,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&mode=drill&item=215000120&drill_id=215000005&page_id=215000003&group=1&desc=BTFG',54)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7199,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&page_id=215000006',24)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7269,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&page_id=215000010',3)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7271,'/scripts/objects/consolemaster.asp?_XID=80000004&_Ref=450493&showall=false&mode=listitself&item=215000200&page_id=215000006&group=1&desc=Operations%20Executive',3)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7282,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=215000001&_item=68&process=215000001&step=215000003&elem=215000018',2)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7289,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=225000001&_item=75&_parenturl=1',1)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7290,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=215000016&_item=86&_parenturl=1',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7311,'/scripts/objects/edit.asp?_XID=80000003&_Ref=450493&_table=225000001&_item=75',11)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7312,'/scripts/objects/showpopup.asp?_XID=80000003&_Ref=450493&_table=225000001&_item=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?_XID=80000003&_Ref=450493&_table=225000001&_item=75&destable=225000001&_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=80000003&_Ref=450493&_table=225000001&_item=90&process=&step=&elem=',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7315,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=225000001&_item=90',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7316,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=225000001&_item=90&_formtab=0&process=&step=&elem=',0)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7317,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=215000016&_item=86',1)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7318,'/scripts/objects/edit.asp?_xid=80000003&_ref=450493&_table=215000016&_item=86&_formtab=&process=&step=&elem=',1)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7319,'/scripts/objects/edit.asp?_XID=70000028&_Ref=450493&_table=1001000&_parenturl=2&_item=225000001&_formtab=&process=&step=&elem=',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&ParentID=',10)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7322,'/scripts/objects/MyZBF.asp?_XID=19999900&_Ref=1398186089&_Ref2=',9)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7323,'/scripts/objects/list.asp?_XID=70000028&_Ref=1398186089&_reset=true&_table=1002009&|MenuID=40000000',8)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7324,'/scripts/objects/edit.asp?_XID=70000028&_Ref=1398186089&_table=1002009&_item=1000001',1)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7325,'/scripts/objects/list.asp?_XID=70000030&_Ref=1398186089&_reset=true&_table=3001062&|MenuID=40000000',6)
INSERT INTO [stat_hit_pages] ([shp_id],[shp_url],[shp_count]) VALUES
(7326,'/scripts/objects/edit.asp?_XID=70000030&_Ref=1398186089&_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=70000030&_Ref=1398186089&_table=3001062&_item=12&_formtab=&process=&step=&elem=',4)

View 2 Replies


ADVERTISEMENT

Selecting Distinct Data Using Group By

Aug 4, 2013

I have an action log table which records when a registrant record was viewed by a compnay employee. I have an sql query like this:

SELECT [ID]
,[RegistrantID]
,[EmployeeID]
,[UserID]
,[CompanyID]

[Code] ....

and data is like this:

IDRegistrantID EmployeeIDUserID CompanyID VacancyID Action ActionDate
17931629515163213NULL 42013-08-04 16:45:40.457
17921629215163213NULL 42013-08-04 16:45:33.003
1791NULL15163213NULL 32013-08-04 16:45:23.660
1790162959162893NULL 42013-08-04 16:45:09.543

[Code] ....

I want to select distinct views to a registrantid record ( the first ones) in one year. if a registrant was viewed 10 tmes a year then it will show only first time it was viewed. If it was viewed 10 times by an employeed in 2 years then it will show first time it was viewed. if it was viewed by 2 employees of same company 10 times in one year then it first time viewed record will be shown. if it was seen 10 times by 2 employees of two different companies in one year then first record of two companies will be shown. do i need to use group by or what ?

View 1 Replies View Related

Selecting Distinct On 3 Columns In Ms Sql Server

Feb 26, 2006

Hi, I think you can do this in oracle but I'm trying to figure a way to do it in ms sql.. I need to select a distinct combination of columns, like so...

select distinct(ItemName,ItemData,FID) from tblSIFups

Does anyone know how to achieve that? I have multiple data where I shouldn't and I don't have any control over the application so I need to clean it this way.

thanks, nicki

View 1 Replies View Related

Selecting A Distinct Row Query

May 13, 2004

I am trying to append data from a source table to a destination table, the only difference between the tables is that a primary key has been established on the destination table. Problem is, the source table has a handful of duplicate values in the column that corresponds to primary on destination table; so when I run the query I get a primary key conflict. What I'd like to do is select distinct values from the source table to avoid the conflict, but am having trouble getting it to run. Here is the statement-

INSERT INTO cust_master
SELECT DISTINCT cust_master_temp.*
FROM cust_mast_temp LEFT OUTER JOIN
cust_master ON cust_master.temp.CUST_NUMBER = cust_master.CUST_NUMBER

Doesn't seem to be understanding "Distinct"

Any Ideas?

View 2 Replies View Related

Help With A Query (Selecting Distinct Rows As Well As How To Use NOW())

Jan 16, 2008

Hi All,

I'm a beginner in SQL and would like some help with writing a query that needs to:

a) Return the latest time that an event happened (along with the event), and also

b) Determine if this event occurred more than 30mins ago.



For example, Table EVENT consists of the following data:

EVENT DateTime,

A 16/1/08, 14:03:55

B 16/1/08, 14:30:27

A 16/1/08, 17:42:18



I would like the results for the first part of query to be:

EVENT DateTime,

A 16/1/08, 17:42:18

B 16/1/08, 14:30:27

I have tried creating a query based off this thread, but for some reason it kept complaining that the EVENT column in Table EVENT didn't exist.

For the part b), I have no clue as to what I should do apart from that I would need to use NOW().



Any help would be appreciated.



MonkeyMark

View 3 Replies View Related

Counting Query (SQL DataSource) By Selecting Distinct

May 21, 2008

I am trying to write a SQL DataSource Statement that will do the following:
Select the Distinct Dates, count up the number of rows with that date
So for example:
Date                Number with that Date
12/12/2007        3
14/12/2007        2
Database:
12/12/2007         Content 1
14/12/2007         Content 2
12/12/2007         Content 3
14/12/2007         Content 4
12/12/2007         Content 5

View 6 Replies View Related

Help With Getting Distinct Records From Multiple Columns In SQL Query

Nov 3, 2005

I'm exporting the following query to a datagrid, however in the result set, some values are duplicated (for various reasons... mostly old software and poor categorization)...On the records with identical values, I want to look at the account number and the DateOfService fields and search for joint distinct values and only display that...Current Example:  ACCT NUM   |  DATE OF SERVICE  |________________________________   43490          |     10/01/2006  08:15:23  |     35999          |     10/10/2005  12:00:00  |   35999          |     10/24/2005  12:45:30  |   35999          |     10/10/2005  12:00:00  |   35999          |     10/10/2005  12:00:00  |   23489          |     10/15/2006  15:13:23  |Desired Result:  ACCT NUM   |  DATE OF SERVICE  |________________________________   43490          |     10/01/2006  08:15:23  |     35999          |     10/10/2005  12:00:00  |   35999          |     10/24/2005  12:45:30  |   23489          |     10/15/2006  15:13:23  |Here is the query I'm working with... just can't figure out how to join or limit the results to ONLY unique matches in Acct Number AND DateOfService.  "SELECT     tblCH.ProcedureKey AS CPT, tblPC.Description, DATEDIFF(d, tblPat.BirthDate, " & _        " { fn NOW() }) / 365 AS Age,  tblPat.LastName, tblPat.FirstName, tblPat.BirthDate," & _        "  CAST(tblCH.AccountKey AS varchar) + '.' + CAST(tblCH.DependentKey AS varchar) AS Account, tblCH.DateOfService " & _        " FROM         dbo.Procedure_Code___Servcode_dat tblPC INNER JOIN " & _        " dbo.Charge_History___Prohist_dat tblCH ON tblPC.ProcedureKey = tblCH.ProcedureKey RIGHT OUTER JOIN " & _        " dbo.Patient_Info___Patfile_dat tblPat ON tblCH.AccountKey = (tblPat.AccountKey AND tblCH.DependentKey) = tblPat.DependentKey "Any suggestions from y'all SQL gurus?  I have to have this report ready for production by tomorrow morning and this is the last fix I need to make =Thank you =)

View 6 Replies View Related

Select DISTINCT On Multiple Columns Is Not Returning Distinct Rows?

Jul 6, 2007

Hi, I have the following script segment which is failing:

CREATE TABLE #LatLong (Latitude DECIMAL, Longitude DECIMAL, PRIMARY KEY (Latitude, Longitude))

INSERT INTO #LatLong SELECT DISTINCT Latitude, Longitude FROM RGCcache



When I run it I get the following error: "Violation of PRIMARY KEY constraint 'PK__#LatLong__________7CE3D9D4'. Cannot insert duplicate key in object 'dbo.#LatLong'."



Im not sure how this is failing as when I try creating another table with 2 decimal columns and repeated values, select distinct only returns distinct pairs of values.

The failure may be related to the fact that RGCcache has about 10 million rows, but I can't see why.

Any ideas?

View 2 Replies View Related

Using Group By In Query With Three Columns Table

Oct 21, 2005

Hi,I guess my brain stopped but I need help with this. create table #RETURN(  uid int,  cid int,  serviceid int  )
 insert into #RETURN select 44,75,2 insert into #RETURN select 44,76,1 insert into #RETURN select 44,77,3 insert into #RETURN select 45,78,3I need to query this table that will get me a distinct UID with matching  CID  ordered by serviceid from lowest to highest.The solution should look likeuid   cid44   7645   78Thanks

View 2 Replies View Related

Selecting Distinct

Jul 18, 2007

 Hi, This is quite an obvious problem, but for some reason I can't think through the solution. I have two columns, a datetime (datecreated) and an id (FK)  othertableid (id)what I would like to be able to do is select a list of id and datecreated, but only chose the latest row for each id.So I guess it's a bit like a distinct on the id column, but ensuring the date returned is the top date. Please help 

View 1 Replies View Related

Selecting Distinct Records

Sep 1, 2007

Hi,
 I'm just wondering if someone can help me with some SQL syntax stuff.I want to take this sql statement: 
"SELECT TOP 50 tblProfile.chName, tblProfile.intCount FROM tblProfile, tblLinks WHERE (tblLinks.MemberID = tblProfile.MemberID) ORDER BY tblLinks.dtDateAdded DESC;"
 and select only unique "chName's" records 

View 9 Replies View Related

Selecting Distinct Product

Sep 6, 2007

I know "select  distinct ProductId from Product  " selects  one product only  one time  how can i apply the same logic in a query like give bellow  SELECT     I.QuoteRequestItemId,     I.ProductId     ,P.StorePartNumber    from    QuoteRequestItem I  left join Product P     on I.ProductId = P.ProductId ie  product with  same productId  should be considered only oncethere should not be more than one row  with  same productId  

View 2 Replies View Related

Selecting Distinct Rows

Jun 11, 2008

Hi,
I want to select the 8 most saled products from large orders table... the problem is that when i use the "distinct" sentence (something like this- "SELECT TOP 8 distinct id, products, productid FROM tbl_orders ORDER BY id") I get back the distinct of any columns.... (and any ID is distinct, of course), but if i don't include the id's in the distinct sentence, i can't order by id's.
 can i get the last orders, only by distinct product, and not by distinct id, and order them by the id's?
  

View 17 Replies View Related

SELECTing A DISTINCT COUNT?

Nov 30, 2003

I have an SQL statement that looks like the following:

SELECT [Docs-Entities].entityID, entityName, COUNT([Docs-DocsEntities].filename) AS numDocs
FROM [Docs-Entities] LEFT JOIN [Docs-DocsEntities]
ON [Docs-Entities].entityID = [Docs-DocsEntities].entityID
GROUP BY [Docs-Entities].entityID, entityName

but the problem is that numDocs (the COUNT) is not returning a distinct count. In the DocEntities table, a particular document can actually have multiple entries with the same entityID so that produces inflated numbers for numDocs. But when I do a SELECT DISTINCT on a particular entityID, the results are less and don't match the numDocs number because I only need to list the document one time. This is not a huge issue, but it looks bad on my site.

Is there a way that I can make COUNT count distinctly?

Thanks for the help and I hope I worded that cllearly...

View 2 Replies View Related

Selecting Distinct Rows ??

Oct 27, 1998

View 3 Replies View Related

Selecting Distinct Records Through CTE

Jan 11, 2013

I have a table contains information related to sales:

SO number Order Date     Customer SellingPerson
1001          2012/07/02     ABC          Andy
1002          2012/07/02     XYZ           Alan
1003          2012/07/02     EFG          Almelia
1004          2012/07/02     ABC         John
1005          2012/07/02     XYZ          Oliver
1006          2012/07/02     HIJ           Dorthy
1007          2012/07/02     KLM          Andy
1008          2012/07/02     NOP         Rowan
1009          2012/07/02     QRS          David
1010          2012/07/02     ABC          Joey

Now, i want to write a query using CTE that gives me first five distinct customer in result set:

SO number Order Date     Customer SellingPerson
1001          2012/07/02     ABC          Andy
1002          2012/07/02     XYZ           Alan
1003          2012/07/02     EFG          Almelia
1006          2012/07/02     HIJ           Dorthy
1007          2012/07/02     KLM          Andy

I wrote this query :

With t(so_number,order date,customer, SellingPerson)
as
  (select top 5 so_number,order date,customer, SellingPerson from t)
 select distinct billingcontactperson from t order by so_id

And getting this error:

Msg 252, Level 16, State 1, Line 1
Recursive common table expression 't' does not contain a top-level UNION ALL operator.

View 9 Replies View Related

Selecting Distinct Records Quickly

Mar 26, 2007

Good day,

I have a table of approximately 10 million rows. The table has 3 field making up the key, namely:
ID, Date, Program

I need to extract all the distinct Program's from the table.
I have don so with:
Select distinct Program from table
This unfortunately takes roughly 2 minutes which is far to long. Is there something I can do to help speed this process up?

Thanks in advance.

View 14 Replies View Related

Selecting Distinct Top 3 Rows From Database Using Join

Jun 25, 2007

Hi guys,

Just trying to select a set of Articles from a SQL Server Database. The Articles all have a Category ID which is stored in another table (as an Article could be in more than one Category). I want to select the Top 3 Articles in a Category. At the moment I have as my SQL;

"SELECT TOP 3 f.ArticleID, f.Heading, f.Summary, f.WrittenDate, f.ArticleURL FROM feedTable f LEFT JOIN Categories c ON f.ArticleID = c.ArticleID WHERE c.CategoryID=" + CategoryID + " AND c.ArticleID<>" + id + " ORDER BY c.CategoryID"

Which seems to work to an extent in that I do get three articles in the same Category appearing. However, there are sometimes duplicates appearing, so I need to incorporate a DISTINCT clause to the above. I'm not sure where to put this in though. Any ideas?

Thanks.

View 6 Replies View Related

Selecting The Newest Records For Distinct Users

Oct 5, 2007

I have the following Table:DataIDuserIDTimeStampI need to create a query that selects the "newest" records for all distinct users. I'm hoping to get this done in one query. I know I could write multiple queries to find all distinct users, and then the newest records based on that... and so on... but I'm not sure that's the most efficient. I have the following so far, but is it the most efficient (I have indexing on most of my columns)?  SELECT DATA.DataID, DATA.UserID, UN.vchName, UN.vchImage, U.vchFirstName + ' ' + U.vchLastName AS 'FullName' FROM [tblData] DATA INNER JOIN [tblUnits] UN ON DATA.UserID = Un.UserID INNER JOIN [tblusers] U ON U.UserID = UN.UserID WHERE GPS.intGPSDataID IN (SELECT MAX([tbLData].DataID) FROM [tbLData] GROUP BY [tbLData].UserID)  

View 4 Replies View Related

Selecting Distinct Rows ?? From Over 10 Mill Records

Oct 27, 1998

hi, I have a table that contains 11,169,000 rows that was downloaded from the main frame. There are alot of duplicate records in that table. I ran a query select * from tbl.... it still running and running and running ... it never stoped.... what seems to be the problem.... There are no primary keys or index in that table...
so my question , how would I deal with such table ... I want to run certain reports from that table and it seems that all my attempts failed? anyone can help

View 5 Replies View Related

T-SQL (SS2K8) :: Selecting Distinct From Multiple Tables

Jun 4, 2014

I have 3 tables:

News:

bigint NewId
nvarchar NewTitle
datetime NewDate
nvarchar NewBrief
--------------------------
Category:

int CatId
nvarchar CatName
--------------------------
NewsRelCategory:

bigint Id
int CategoryIdFk
bigint NewsIdFk
--------------------------

I want to select NewId, NewDate and Distinct NewTitle

I tried this but NewTitle doesn't distinct:

SELECT
FROM dbo.Category INNER JOIN
NewsRelCategory ON dbo.Category.CatId = NewsRelCategory.NrcCategoryIdFk INNER JOIN
dbo.News ON NewsRelCategory.NrcNewsIdFk = dbo.News.NewId

View 9 Replies View Related

Selecting All Distinct Names With Most Recent Corresponding Status

May 25, 2014

I have a DB with the fields: Id, Date, Name, Status.

Now I want to select all distinct names with the most recent corresponding status.

With the SELECT DISTINCT Name, I get only one record per different name which is ok.

Now I want to add next to each different name, the most recent added status.

Can I combine those 2 in 1 query? I want to show them using PHP on a website.

Now I get a table with a row for each different name, but I can't add a second column where the most recent Status is showed for that name.

View 1 Replies View Related

T-SQL Problem...selecting TOP 1 Of Each GROUP In GROUP BY?

Jul 23, 2005

Hi,I was hoping someone may be able to help me with a tricky T-SQLproblem.I need to come up with a SELECT statement that does basically thefollowing:Select RCRD_REFNO, MAX(MODIF_DTTM) as MODIF_DTTM from[StageDb].[dbo].tblPersonInfo group by RCRD_REFNOHowever, I need to select ONLY the TOP 1 of each group (i.e. only 1record for each unique RCRD_REFNO). The problem is of course that if Iadd 'top 1' after select, it only brings back 1 record full stop,rather than 1 for each group!Now, I have previously come up with a similar query that DOES do thissuccessfully, but it relies on a criteria (such as a unique identifier)-unfortunately, the nature of the table I'm using for this currentjob means that it actually doesn't have a primary key, as it'ssimply a staging area for raw data, and can even have completelyidentical records in it. I think the only way I'm going to be able todo it is to literally use the 'TOP' command somehow, but am notsure how to adapt the above to implement it...I'd be very gratefulfor any advice.Many thanks

View 6 Replies View Related

Selecting Nearby Distinct City/zipcode Issue

Mar 12, 2004

I have the following code, which returns a list of nearby cities based on a city name as input. Most cities have multiple zipcodes per city name, thus it can list multiple rows with the same city name, but with different zipcodes like below:

Zip | Cityname
111 belmont
112 belmont
113 belmont
114 san francisco
115 san francisco

---------------- etc----------------

I do not really care about each group of zipcodes. I only need one pair of zipcode/city name like the following:

ZIP | City name
111 belmont
114 San Francisco


How do I change my select to only return a distinct city name. I do not care which if the city/zipcodes it returns from the similar city.

The select statement is below:




CREATE PROCEDURE ZipSearchByCity
@city varchar(40),
@State varchar(5),
@distance int


AS


SELECT distinct o.City AS City, o.zip_code, o.State AS State,
(3956 * (2 * ASIN(SQRT(
POWER(SIN((z.RADlatitude-o.RADlatitude)/2),2) +
COS(z.RADlatitude) *
COS(o.RADlatitude) *
POWER(SIN((z.RADlongitude-o.RADlongitude)/2),2)
)))) dist

FROM zipcodes z,
zipcodes o,
zipcodes a




WHERE z.city = @city AND
z.State = @State AND
z.zip_code=a.zip_code AND
(3956 * (2 * ASIN(SQRT(
POWER(SIN((z.RADlatitude-o.RADlatitude)/2),2) +
COS(z.RADlatitude) *
COS(o.RADlatitude) *
POWER(SIN((z.RADlongitude-o.RADlongitude)/2),2)
)))) < @distance
GO





Thanks,

Christian

View 7 Replies View Related

Selecting First Row From GROUP BY

Jul 20, 2005

Hi,I having problems returning only the first row of data for each GROUPfor the query below. Can someone please help? Thanks.SELECT bid, xact_date, xact_timeFROM badge_history bhGROUP BY bid, xact_date, xact_timeORDER BY bid, xact_date DESC, xact_time DESCSo if the data returned by the above query is:bid xact_date xact_time-------------------------------------------------0000000025697510200212051118220000000025697510200212051118160000000025697510200212051118101517440346432003012211324415174403464320030117165815151744034643200301171657571517440346432003011716573915174403464320030117165727Then I need the new query to produce:bid xact_date xact_time-------------------------------------------------00000000256975102002120511182215174403464320030122113244Can anyone suggest anything that might work!? Thanks again.

View 2 Replies View Related

Trying To Add A NON-DISTINCT Field To A DISTINCT Record Set In A Query.

Mar 12, 2007

I need to run a SELECT DISTINCT query acrossmultiple fields, but I need to add another field that is NON-DISTINCTto my record set.Here is my query:SELECT DISTINCT lastname, firstname, middleinitial, address1,address2, city, state, zip, age, genderFROM gpresultsWHERE age>='18' and serviceline not in ('4TH','4E','4W')and financialclass not in ('Z','X') and age not in('1','2','3','4','5','6','7','8','9','0')and (CAST (ADMITDATE AS DATETIME) >= DATEDIFF(day, 60, GETDATE()))ORDER BY zipThis query runs perfect. No problems whatsoever. However, I need toalso include another field called "admitdate" that should be treatedas NON-DISTINCT. How do I add this in to the query?I've tried this but doesn't work:SELECT admitdateFROM (SELECT DISTINCT lastname, firstname, middleinitial, address1,address2, city, state, zip, age, gender from gpresults)WHERE age>='18' and serviceline not in ('4TH','4E','4W')and financialclass not in ('Z','X') and age not in('1','2','3','4','5','6','7','8','9','0')and (CAST (ADMITDATE AS DATETIME) >= DATEDIFF(day, 60, GETDATE()))ORDER BY zipThis has to be simple but I do not know the syntax to accomplishthis.Thanks

View 2 Replies View Related

GROUP BY Vs. DISTINCT

Jan 22, 2008



I am looking for a document or article that explains when it would be best to use a GROUP BY, or DISTINCT.

Cheers,

Casey

View 4 Replies View Related

Selecting Top Record In A Group?

Mar 18, 2015

I’m writing a document management system. The documents themselves are created from the contents of a database. The database is SQL Server.

The database contains a table, like so:

ClientID, ProjectID, DocumentID, MinorVersion, MajorVersion, Name

Initially, the user will create a “V0.1” document. So the data would look something like

ClientID = 1
ProjectID = 1
DocumentID = 1
MajorVersion = 0
MinorVersion = 1
Name = “My Document”

Thereafter, the user can create new versions as “0.2”, “0.3”, etc., or “1.0”, “1.1”, “2.0”, etc.

For example, a “2.1” document would be stored as:

ClientID = 1
ProjectID = 1
DocumentID = 1
MajorVersion = 2
MinorVersion = 1
Name = “My Document”

The earlier versions will still exist on the database, but the latest version will be 2.1.

There may be several different documents, with different DocumentID’s (e.g. DocumentID = “1”, DocumentID = “2”), etc., and each of these documents may have many versions.

I’m trying to write a query to display a list of documents showing ClientID, ProjectID, DocumentID, MinorVersion, MajorVersion, Name… but the list should only display the latest version of each document.

So, if the database contained the following records:

ClientID, ProjectID, DocumentID, MajorVersion, MinorVersion, Name
1,1,1,0,1,My Document
1,1,1,0,2,My Document
1,1,1,0,3,My Document
1,1,1,1,0,My Document
1,1,1,2,0,My Document
1,1,1,2,1,My Document
1,1,2,0,1,My Second Document
1,1,2,0,2,My Second Document
1,1,2,0,3,My Second Document

My query should return:

ClientID, ProjectID, DocumentID, MajorVersion, MinorVersion, Name
1,1,1,2,1,My Document
1,1,2,0,3,My Document

… where 2.1 is the latest version of Document 1 and 0.3 is the latest version of Document 2.how to do it.

View 4 Replies View Related

DISTINCT Or GROUP BY Does Not Work. Help

Oct 17, 2002

I have have a column where there would be some duplicate records, but I have tried using the IN list, DISTINCT, and GROUP BY, and it does not give me distinct record set.

However DISTINCT and GROUP BY will work as long as my columns to display remain only one, but the minute I add more columns to my SELECT statement it does not make them distinct anymore.

Example 1 works, but Example 2 does NOT. In Example 2, I have added more columns otherwise it identical to Example 1. In Example 3, I was using the IN list, but the results of Example 3 is identical to Example 2 !!

EXAMPLE 1:
SELECT DISTINCT email_address AS Email
FROM email_address
WHERE Send = 'y' and (DATEDIFF(DAY, Sent, getdate()) > 30)

EXAMPLE 2:
SELECT distinct email_address AS Email, email_address_ID AS ID, Sent
FROM email_address
WHERE Send = 'y' and (DATEDIFF(DAY, Sent, getdate()) > 30)

EXAMPLE 3:
SELECT email_address_ID AS ID, email_address AS Email, Sent
FROM email_address
WHERE email_address IN (SELECT DISTINCT email_address FROM email_address
WHERE Send = 'y' and (DATEDIFF(DAY, Sent, getdate()) > 30))

View 2 Replies View Related

Group By Or Distinct - But Several Fields

Feb 11, 2014

How can I use a Distinct or Group by statement on 1 field when calling All or at least several ones.

Example:
SELECT id_product, description_fr, DiffMAtrice, id_mark, id_type, NbDiffMatrice, nom_fr, nouveaute
From C_Product_Tempo

And I want Distinct or Group By nom_fr

View 19 Replies View Related

T-SQL (SS2K8) :: Select Group On Multiple Columns When At Least One Of Non Grouped Columns Not Match

Aug 27, 2014

I'd like to first figure out the count of how many rows are not the Current Edition have the following:

Second I'd like to be able to select the primary key of all the rows involved

Third I'd like to select all the primary keys of just the rows not in the current edition

Not really sure how to describe this without making a dataset

CREATE TABLE [Project].[TestTable1](
[TestTable1_pk] [int] IDENTITY(1,1) NOT NULL,
[Source_ID] [int] NOT NULL,
[Edition_fk] [int] NOT NULL,
[Key1_fk] [int] NOT NULL,
[Key2_fk] [int] NOT NULL,

[Code] .....

Group by fails me because I only want the groups where the Edition_fk don't match...

View 4 Replies View Related

Distinct, Unique, Group By, 'Footing'?

Jun 13, 2007

I created an ouput text file that was perfect until specs were revised today to add quarterly tax and deduction summations for each employee. (Expected turnaround time for new spec: today!)

So my employee record now has 8 records (which I expected) because I had to join it to the pay_summary table. Like this:

SELECT
COALESCE(CONVERT(char(1),e.record_status),'')
+ COALESCE(CONVERT(char(4),'97 '),'')
and many more fields
from employees as e
JOIN emp_taxes as t on e.employee_no = t.employee_no
LEFT OUTER JOIN pay_summary AS p ON e.employee_no = p.employee_no

Where
dateadd(d, 0, datediff(d, 0, p.dated)) BETWEEN '20061231' AND '20070401'

and e.record_status not like 'D'
and t.tax_authority_type = 'F'
and e.company_no = '2' and e.employee_no = t.employee_no

order by e.employee_no

There are 6 or so fields I intend to sum as records to go into the
file. In another language, in order to get one record per employee_no, the syntax would be like this:

sort on employee_no
footing at employee_no
report field_a field_b field_c subtotal field_e field_f subtotal

in which case fields c and f are numeric and summed from the multiple pay_summary records.

What is the (most efficient) SQL command to give only one record per
employee while summing all the detail records?

I can't thank you guys enough for this forum.

Lisa

View 9 Replies View Related

Error In Group By And Distinct Clauses

May 2, 2008



hai,
i'm using a table in sql.the name of register. the table datas are

FirstName LastName UserName Pwd dob
krishna murthy ckm0006 asdfg 1985-04-01 00:00:00.000
krishna dfgd ckm0006 cxbcv 1985-05-01 00:00:00.000
raja fdd ddd ddd 1985-01-01 00:00:00.000
raja hgff fgrgf fgf 1985-02-01 00:00:00.000

i want the result as:[group by or distinct by FirstName && order by dob]

FirstName LastName UserName Pwd dob

krishna dfgd ckm0006 cxbcv 1985-05-01 00:00:00.000
raja hgff fgrgf fgf 1985-02-01 00:00:00.000

i tried many queries i'm getting error Like this


Column 'register.LastName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

can anyone resolve my problem...

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved