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 SkipVought 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: mbaza3
  • Order by date
  1. mbaza3

    select count(*) for success in DTS

    I would test it in Sql 7.0 as well. The interesting thing is when I contactd Microsoft about this they could not duplicate the error. Maybe it will not fail in your environment. I would be curious to know. Thanks. Joe
  2. mbaza3

    select count(*) for success in DTS

    If you are in SQL 2000 the divide by zero error will work. However if you are in SQL 7 it will not. If the error is not generated in the first line of the execute sql task code, the task will not fail not matter what happens in the execute sql task. Ex. execute sql task: select @@version...
  3. mbaza3

    How do I issue return codes in a VB App

    Did you ever figure this out? I would be interested in how you did it. Thanks.
  4. mbaza3

    complex nested query

    This should work: SELECT i.EmployeeNum, c.Managernum AS CorpITManager FROM employees i INNER JOIN (SELECT * from employees) r ON i.Managernum = r.EmployeeNum INNER JOIN (SELECT * from employees) c ON r.Managernum = c.EmployeeNum
  5. mbaza3

    Operator

    I left an error in the prior select. Here is the code which will work. SELECT itemno, description FROM mytable WHERE LEFT(class,1) IN ('A','B','C')
  6. mbaza3

    Operator

    There is no direct equivalent of the VFP "$" (contained in)function in T-SQL. Below is an example of something that will give you simliar results. SELECT itemno, description FROM mytable WHERE LEFT(class,1) IN ('A','B'C')

Part and Inventory Search

Back
Top