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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- SQLDog
- Thread
- Replies: 6
- Forum: Microsoft: Windows servers
-
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...- SQLDog
- Thread
- Replies: 14
- Forum: Microsoft SQL Server: Programming
