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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ASP multiple search forms using a SP
Hello, I'm using a 3 form input search form to return a result of Author names, example Name, FirstName and Title. I'm using a SP to search with these 3 inputs to return a recorset. Is using the Like with the '%' the best way to do so? What about if the fields are empty? Does someone have an...- flebel
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
ASP-ADO creating a Select Query that calls another query.
Hello, Here is my situation: I have two tables, a reservations table and a schedule table. I'm making an ASP page that looks up the schedule of an employee but it must remove the reservations allready made from this employee from the reservations table. Here are my table structures: schedule...- flebel
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Querying a query inside another query !
Hello, I'm fairly new to SQL server 2000. I have used access and now moving to SQL. Here is my question: I have created a view(query) that needs to look up inside another view(query). This other query has variables. In a select query, how to I pass variables to the second query? I know nothing...- flebel
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
