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 Rhinorhino 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: NickW2
  • Content: Threads
  • Order by date
  1. NickW2

    Findfirstfile gives getlasterror 183 (error_already_exists)

    When using findfirstfile, it returns INVALID_HANDLE_VALUE, with getlasterror set to 183 (error_already_exists). Can anyone explain what this error means in this context?
  2. NickW2

    problem using rtrim in select when outputting to file with isql

    When outputting to a file with isql under SQL Server 2000, even if the select statement uses RTRIM on a column, it is still output with trailing spaces. Is there any way to force the removal of the trailing spaces?
  3. NickW2

    SQL Server 2000 DTS Package moved but @@servername returns orig name

    Under SQL Server 2000. I have a DTS Package which runs a query in an Execute SQL Task which references @@servername. This works fine. However, when I did a "save as" to copy the package to another server, and execute the package on the new server, @@servername strangely appears to return the...
  4. NickW2

    SQL Server 2000 DTS Package Dynamic Properties query not working

    I am trying to use a Dynamic Properties task for the first time. I have a DTS Package containing a transform data task which outputs to a file named "\\servername\folder\xxxxxx.csv". I have set up a dynamic properties task which uses a query SELECT...
  5. NickW2

    Select to give ordinal number of values in another column

    If you have a table, say, with 2 columns Nominal number (N1,N2,...Nn) Casualty? (Y/N) Is there an easy way of selecting (deriving) an (ordinal) casualty number, which is not stored as a column. e.g. if you had the following data N1 Y N2 N N3 Y N4 Y N5 N selecting...

Part and Inventory Search

Back
Top