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 Chriss Miller 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: dwhdwh
  • Content: Threads
  • Order by date
  1. dwhdwh

    passing multiple numeric values as a parameter

    I have a requirement where I want to pass multiple key values to select data from a table as below: CREATE PROCEDURE a (@jobno varchar(100)) AS select * from TabA where JobNo in (@jobno) I cannot however pass in more than 1 key as it fails: exec a '8002,8003' Syntax error converting the...
  2. dwhdwh

    Session idle timeout over, tearing down the session

    If I view my event viewer, I occasionally see the above informational message in the Event Viewer Application Log, issued from MSDTC. Is this something that is a potential problem, does it mean I am not freeing something correctly? Thanks, Dave.
  3. dwhdwh

    I want to pass the 'IN' clause value into a stored procedure

    Does anyone know how to pass a value into a stored procedure which can be used in an 'IN' clause. It works fine passing 1 value, but I cannot get it to work passing in multiple values. Example: Select * from Members Where State_Id in ('FL', 'MA') How can I pass 'FL', 'MA' as the parameter...
  4. dwhdwh

    How to pass a value to an 'IN' clause in a stored procedure?

    I want to be able to pass a parameter into a stored procedure to be used in an IN clause. An example would be: Select * from Members Where State_Id IN ('NJ','NY','MD') So I want to pass the states as a variable. Anyone know how to do this in either SQL Server or Oracle. Thanks, Dave.

Part and Inventory Search

Back
Top