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 about stored procedures, as I'm quite new to SQL server.
thank you for you help.
Francis
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 about stored procedures, as I'm quite new to SQL server.
thank you for you help.
Francis