SQL QUERY REQ - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL QUERY REQ

Author

Topic

harikiranjammul
Starting Member

2 Posts

Posted - 2011-11-28 : 14:35:45

I need a small help on SQL query.

I have two tables RESPONSETIME00 & RESPONSETIME02, I need to count the URL’s such that how many times it was requested. I am attaching two tables & the output which I am looking for. Let me know how to get the attached output from the two tables.

Table 1 :

ID1 Node_Name ID4 ID7
10.150.3.1 SERVER5 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER3 [28/Nov/11:23:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:22:09:10 /reuest-transfer
10.150.3.1 SERVER8 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:15:09:10 /i3-soft/com
10.150.3.1 SERVER6 [28/Nov/11:17:09:10 /i3-soft/com
10.150.3.1 SERVER5 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:17:09:10 /reuest-transfer
10.150.3.1 SERVER3 [28/Nov/11:23:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:17:09:10 /reuest-transfer

Table 2 :

ID1 Node_Name ID4 ID7
10.150.3.1 SERVER1 [28/Nov/11:15:09:10 /i3-soft/com
10.150.3.1 SERVER3 [28/Nov/11:15:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:17:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:17:09:10 /reuest-transfer
10.150.3.1 SERVER1 [28/Nov/11:22:09:10 /reuest-transfer
10.150.3.1 SERVER4 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:15:09:10 /i3-soft/com
10.150.3.1 SERVER6 [28/Nov/11:17:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:17:09:10 /i3-soft/com
10.150.3.1 SERVER3 [28/Nov/11:23:09:10 /i3-soft/com
10.150.3.1 SERVER1 [28/Nov/11:17:09:10 /i3-soft/com

output i am looking for

ID7 Count
/i3-soft/com 16
/reuest-transfer 12

malpashaa
Constraint Violating Yak Guru

264 Posts

Posted - 2011-11-28 : 23:08:34

Duplicate post

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=168457

For us, there is only the trying. The rest is not our business. ~T.S. Eliot

Muhammad Al Pasha

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources