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 Wanet Telecoms Ltd 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: jl39775
  • Content: Threads
  • Order by date
  1. jl39775

    Dynamic Where in Stored Procedure help

    Hi all, I have a web application that has a search engine that returns records based off what the user selects in the search engine. I am currently using coalesce in the where statement in my stored procedure to return the records. For eample, where field1= coalesce(@parm1,field1). I don't know...
  2. jl39775

    Trouble w/Query

    I have two tables with a 1 to many relationship. For example table1 (parent) id(key) col1 col2 table2 (child) id (foreign key) col1 Is there a select statement that I can use to combine data from both table with the same key into one record when table2 has many related records to table1...
  3. jl39775

    Batch Printing

    Does anyone know how I can print multiple files in one print job. I looked at calling the SetJob api but I do not know how to use it to print multiple files. Can anyone help? Thanks, James

Part and Inventory Search

Back
Top