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!

Register Log in
  • Congratulations IamaSherpa 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: *

  • Users: HBelk
  • Order by date
  1. HBelk

    SQL CALs / Intranet

    Thanks guys. I appreciate the information.
  2. HBelk

    SQL CALs / Intranet

    Here's our SQL CAL scenario. Our company has 1,000 users, but our intranet site is setup to only allow 100 concurrent connections. If there is an ASP page displaying information from SQL Server on that intranet, how many SQL CALs do we need to purchase to be legal? A)100 CALs, since only a...
  3. HBelk

    AutoFilter in Excel with VB/SQL

    I have a rather large spreadsheet with sensitive information per Employee. There are thousands of records. Each line will have the Employee's SSN as an identifier in a SSN column. The HR Department wants to publish this one worksheet but only allow an employee to see his or her information...
  4. HBelk

    Disaster Recovery SQL

    We are currently evaluating different ways to keep our Disaster Recovery SQL Servers in sync with our Production SQL Servers. Log Shipping in SQL Server 2000 Enterprise Edition works well and allows both servers to be running SQL services. It even allows you to view the data on your DR server...
  5. HBelk

    Ordering out of middle

    You could run a case statement in your select: select Toys.*, case when Manufacturer = 'MB' then 1 else 2 end As Manufacturer_OrderBy from Toys Order by Manufacturer_OrderBy The syntax might be a little off. I don't have SQL Query Analyzer on my home computer, but it should close. H

Part and Inventory Search

Back
Top