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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.