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!

  • Congratulations bkrike 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: mashaguen
  • Content: Threads
  • Order by date
  1. mashaguen

    Running DTS Package from a Stored Procedure

    I have to execute a DTS package from a stored procedure. THis is my stored procedure: ------------------------------------------------------- CREATE PROCEDURE dts_staging_to_production AS EXEC xp_cmdShell 'dtsrun /S[servername] /U[username] /P[password] /N[dts package name] GO...
  2. mashaguen

    <b>Removing the trailing semicolon</b>

    How do I remove the trailing semicolon? My results prints out: general, 3/47:31; 4/11:45; I need it to print out: general, 3/47:31; 4/11:45 without the semicolon on the end. Any sugestions? Thanks I would appreciate any help
  3. mashaguen

    Passing a string to a stored procedure

    I am trying to pass a string to the stored procedure by doing this: EXEC multipleIndexA @inventory_item_id=' 4935,11105, 4935' I am not getting any results. Now here is the code of my stored procedure: CREATE PROCEDURe multipleIndexA (@inventory_item_id varchar(500)) as create table...

Part and Inventory Search

Back
Top