Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SQLDog

    How to Cross Connect 2 Servers?

    That is why I was a bit confused with Steve's post. He says "...and then disable NIC 2 on server 2." I figured it was because I wasn't clear with my initial post that the cross-connect was between the NIC 2s on each server. Mike
  2. SQLDog

    How to Cross Connect 2 Servers?

    Thanks for the response Steve! Before I go messing with my production server, let me make sure I get this right. SERVER 1 (Main) NIC 1 IP 192.168.1.1 Subnet 255.255.255.0 NIC 2 IP 192.168.1.100 Subnet 255.255.255.0 Server 2 NIC 1 IP 192.168.1.2 Subnet 255.255.255.0 NIC...
  3. SQLDog

    How to Cross Connect 2 Servers?

    I am trying to create a reporting server. I have 2 hosted servers (windows 2003) each with 2 nic cards. I am trying to setup the cross connect between the two so I can sync data directly. Can anyone help with how to set this up or point me to some resource on how to do this? The two servers...
  4. SQLDog

    selecting top 3 location zip code counts

    Alex, The latest worked like a charm. Thanks for the help and a fine example of how to write a query of this type. Mike
  5. SQLDog

    selecting top 3 location zip code counts

    Thanks Alex! I will give it a try when I get to work tomorrow. Mike
  6. SQLDog

    selecting top 3 location zip code counts

    I need to generate a report with the top 3 zip codes by Location. My tables are Location, Customer, and Address. I have a Select statement like this: Select l.name, a.zip, count(a.zip) as count From location l inner join customer c on c.locationid = location.id inner join address a...

Part and Inventory Search

Back
Top