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 Mike Lewis 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: SriSamp
  • Order by date
  1. SriSamp

    DTS-- suggestion for Book

    The SQL Server BOL is the best bet on this. SriSamp
  2. SriSamp

    Output Trigger Result to Text Doc

    You can use the contents of the "inserted" pseudo table and then use the sp_OA* stored procedures to create the text file on the server. See the SQL Server BOL to get more details on these procedures. Its too huge to mention here... HTH, SriSamp
  3. SriSamp

    Name separation query

    You can search for " " (spaces) between the names and then split them based on that. The CHARINDEX function can be used for this. HTH, SriSamp
  4. SriSamp

    Missing numbers

    There is no single command to find this out. SriSamp
  5. SriSamp

    Reading Excel File accross different server

    Try mapping a path to the location where the file is and then using that location. SriSamp
  6. SriSamp

    How to execute a DTS through an ASP page?

    DTS provides an object library that can be called. To do this, your package can be saved either to SQL Server or as a Structured Storage file. See the SQL Server BOL for more details on how to do this. HTH, SriSamp
  7. SriSamp

    Table Identifier Variable

    If you can send the DDL statement, I can give a more correction solution, but are you concatenating the table variable with the CREATE TABLE statement? SET @statement = 'CREATE TABLE ' + @tcTableName + ' ....' HTH SriSamp

Part and Inventory Search

Back
Top