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 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: *

  • Users: mitchsrf
  • Content: Threads
  • Order by date
  1. mitchsrf

    Creating SQL Query with IF Statement in a View

    I need a different query depending on what time of the day it is. Using Query Analyzer, I can use IF statements to get the result I want. When I put that SQL query in a view and check the syntax it gives me errors. Is it possible for a VIEW in SQL Server 7.0 to contain SQL query with IF-ELSE...
  2. mitchsrf

    Casting error prevents data from being imported (using DTS)

    Hello, I've implemented a DTS job that imports data from a Microsoft Access database (via ODBC) into SQL server 7.0. The Access DB has about 51,000 records. At row 36,899 the importing stops and an error message says there's a casting error. The row did not contain any odd data, it was similar...
  3. mitchsrf

    Login Error from NT Workstation but not from Webserver

    Hi, I have an ASP page on a webserver running IIS 4.0 that gets data from a table in the 'master' database on an SQL Server (ver. 7.0). The records from the table are displayed on the ASP page when I open the page on the webserver. However, when I access the same address from any other...

Part and Inventory Search

Back
Top